USER_PROBLEM

[Arsalan]

Hello Erman Arslan,

I create user in oracle 11g, without give any type of privileges to that user,

so that user can retrieve data of some table of other schema but

some tables of other schema can not retrieve  i will send u example.

even that user can do DML also on some table please guide i am very confused,

i check all privileges,roles etc i did not found any type of privilege which i give to users.

even i did not found trigger also


A.PNG

 

[Arsalan]

Salam, Arslan,

The mention problem have found some one have granted select,update privileg to public,

is there any query to find Person who granted select,update privilege to PUBLIC ?

[ErmanArslansOracleBlog]

Hi,

If you are auditing the GRANT actions, then yes you may find the one who granted that privilege to PUBLIC.
DBA_AUDIT_STATEMENT displays audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements throughout the database...

[Arsalan]

Thanks a lot for your great information Arslan