diteps06
asked on
Oracle grant privilege of INSERT/OBJECT CREATION
What are the instructions to grant the privilege of insert and object creation on a user A to another user B.
The user B has to have the privilege to INSERTand CREATE OBJECT on user A
The user B has to have the privilege to INSERTand CREATE OBJECT on user A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- hi diteps06, sorry for the late reply. the expert - wasimibm, already respond the right approach. login sys (as sysdba) or system user then grant the above mention steps. you can also use "grant create any table to userB".
ASKER
It doesn't the privilege to execute such a statement.
I have access to a DBA account.
Should user A be a DBA?