-
Contributing Member
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.
-
Expert Member
Re: Grant
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..)
-
Re: Grant
you can't do all that in a single statment . Do as suggested by our expert. you might need previliges on the objects.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules