How to give select privilege on all the objects owned by an user(say user1) to another user say(user2) using a single sql statement?

Interview Candidate
Jul 30th, 2007
12
3479

Showing Answers 1 - 12 of 12 Answers

g_sidhu
Profile

Feb 12th, 2008

A privilege that is granted with the WITH GRANT OPTION clause can be passed on to other users and roles by the grantee. Object privileges granted with the WITH GRANT OPTION clause are revoked when the grantor’s privilege is revoked.

shinehere
Profile Answers by shinehere

Mar 4th, 2008

You can try this command

GRANT SELECT ON ALL TO USER2

yagneswarasankar
Profile Answers by yagneswarasankar

Nov 24th, 2010

SQL> conn sample/sample;
Connected.
SQL> select count(1) from girija.employees;
select count(1) from girija.employees
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> conn girija/******;
Connected.
SQL> grant all privileges to sample;
Grant succeeded.
SQL> conn sample/sample
Connected.
SQL> select count(1) from girija.employees;
COUNT(1)
----------
20