How to revoke alter table rights.
- A -Jan 21 2010 — edited Jan 21 2010Hi,
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