Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to revoke alter table rights.

- A -Jan 21 2010 — edited Jan 21 2010
Hi,

I am using oralce 10gR1 on windows.I have a user with the name of "HRMS" has system privilege.

SQL> select * from dba_sys_privs where grantee='HRMS';

GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
HRMS CREATE TRIGGER NO
HRMS CREATE PROCEDURE NO

And want to revoke alter table rights from this user.In above command it has only two privilege but this user can do alter table.Please tell me how i restrict this user. one thing is more this is schema user.


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2010
Added on Jan 21 2010
15 comments
2,553 views