Re: about grant problem

The user student may have a system privilege, such as "dba" or "select any table", which allows the student to continue to select from the test table even when the specific object privilege has been revoked. To check this, try

 select * from dba_role_privs where grantee = 'STUDENT';

and see if the user has system privileges that might allow it to perform the select.

The "select on test" object privilege that scott granted to student using "the select with grant option" privilege from system should be revoked from student as well as scott when the select object privilege is revoked from scott. (This is not the case with system privileges granted through the admin option.)

Frank Hubeny

johnsonlu wrote:

> hi all
> In the database ,It's has tree user account(system,soctt,student) ok!!
> I created table test owner system.
> first command:
> user:system
> grant select on test to scott with grant option;
> second command
> conn scott/tiger
> grant select on system.test to student.
> When I revoke scott privilege (select to system.test),but USER STUDENT ,It
> still can select to system.test
> How can I revoke student privilege?
> if you have any answer ,pls return to me or return to my e-mail
> :johnsonlu_at_ms30.url.com.tw
> thanks!!
Received on Tue Jul 04 2000 - 00:00:00 CDT