Thread: Grant

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 single grant statement 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.