-
grant insert privileges - error insufficent privileges
Logged into the database base as sys, then created a user A and tried to grant him insert privileges to table test which exists in schema B.
SQL> grant insert on B.TEST to user A;
I get the error insufficient privelages.
So I logged into the schema b and gave the privileges to the user A, which succeded. Not sure why I could not grant the insert privileges against another schema to a user, if I am logged in as sys or system.
-
because you don't have the privilege to grant privileges on other peoples objects. http://download-west.oracle.com/docs...6privs.htm#849
Jeff Hunter
-
Is that true even if you are logged in as SYSTEM or SYS.
"Because you don't have the privilege to grant privileges
on other peoples objects. "
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|