grant

i gotta grant select permission on all objects of the user A to user B...

is it possible to do with a single statement.....

i mean not like
Grant Select on A.table1,A.table2,.... to B;

can i do som thing like
Grant Select on All Tables to B;

Abhay

Code:

---

begin
  for i in (select * from user_tables)
  loop
    execute immediate 'grant select on '||i.table_name||' to scott';
  end loop;
end;
/

---

Thanks Pando....

But i wanted to know if u have a single attribute which grants on all objects....as say u can give all PREVILAGES by ALL

GRANT ALL on Table_Name to User;

I was wondering if somthing similar we have in this case.

Abhay.

no

logical, when you say ALL tables how does Oracle suppose to interpret that?

it's all in the docs

Pando :

i got it.....
U can do it by

Grant Select ANY TABLE to User;

Regards
Abhay.

well that's not granting privs on objects, SELECT ANY TABLE is a system privlege and of course if you do that the user can see any table, logical and dangerous

Quote:

---

Originally posted by abhaysk
i gotta grant select permission on all objects of the user A to user B...

is it possible to do with a single statement.....

i mean not like
Grant Select on A.table1,A.table2,.... to B;

can i do som thing like
Grant Select on All Tables to B;

Abhay

---

Remark: We, as DBAs, can grant select on a table owned by user A to user B only starting from 9iR2.