Dear All,
I need to grant only SELECT privilege on entire Database to a particular user
with a single GRANT statement.
Kindly suggest your opinions regarding the same.
Have a pleasant time.
Printable View
Dear All,
I need to grant only SELECT privilege on entire Database to a particular user
with a single GRANT statement.
Kindly suggest your opinions regarding the same.
Have a pleasant time.
Select 'grant all on '||object_name||' to username' from all_objects where object_type ='table';
or
select 'grant all on '||object_name||' to username' from userl_objects where object_type ='table';
spool this and save it as sql file and run in sqlplus.in above query u need to change username. I think to grant only select privilege on entire database to a particular user with a [b]single grant statement [/b] is not possible (i am not sure..)
you can't do all that in a single statment . Do as suggested by our expert. you might need previliges on the objects.