Travis Tran

Travis Tran

BREAKTHROUGH the limits

Grant privilege on all objects in a Schema to a user in Oracle Database

In this example I have given select on all tables in schema test1 to user test2. As well grant all DML privilege on tables and views, and grant execute on procedures, functions and packages in a schema test1 to user test2.

SQL> create user test1 identified by test1;
User created.
SQL> grant connect,resource to test1;
Grant succeeded.
SQL> create user test2 identified by test2;
User created.
SQL> grant connect,resource to test2;
Grant succeeded.
SQL> conn test1/test1
Connected.
SQL> create table test_table1(id number,name varchar2(30));
Table created.
SQL> create table test_table2(id number,name varchar2(30));
Table created.
SQL> show user;
USER is "TEST1"

If you want to grant select privilege:

Continue reading
X
Glad to have you at travistran.me
Welcome to TravisBot
wpChatIcon