Is this revoke command is right ??

Im not getting you what you are saying .Im confused.

what is the command then to revoke privilege from role?

Regards,

Thanks for your link.


Revoke select from B;

where
select -- privilege
B -- role

Is this revoke command is right ??


Regards,

SQL>  create role sriram_role identified by sriram;
Role created.

SQL> grant select to sriram_role;
grant select to sriram_role
      *
ERROR at line 1:
ORA-01919: role 'SELECT' does not exist

SQL> grant select on scott.emp to sriram_role;

Grant succeeded.
SQL> revoke select on scott.emp from sriram_role;

Revoke succeeded.

i want to revoke only the particular privilege 'SELECT' or 'EXECUTE' from the role?

is that not possible ?

Regards,

Hitman , Sriram already gave a nice example to revoke the select priv from a user/role.

You need to repeat the below syntax on all the tables you want.

revoke select on scott.emp from B;
revoke select on scott.tmp from B;
revoke select on scott.sal from B;
revoke select on scott.grade from B; and so on.

Re: Revoke privilege Tue, 10 November 2009 05:23
Hitman11


i want to revoke only the particular privilege 'SELECT' or 'EXECUTE' from the role?

is that not possible ?

Regards,