Link to home
Start Free TrialLog in
Avatar of ajs_tech2516
ajs_tech2516Flag for United States of America

asked on

grant 'Select any table' versus individually granting select on each table in Oracle

I have granted privilege 'Select Any Table'  to a schema. Is there any difference between granting access using 'Select Any Table' method versus individually granting access to each table using 'Grant Select on' method? thanks!!
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Yep.  'any table' means any table in the entire database.  System, SYS, other schemas, etc...
Avatar of ajs_tech2516

ASKER

okay thanks, but wud it make any difference as far as other tables are concerned
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial