Home » Developer & Programmer » Forms » *** Granting Privilegs to user, How? ***
*** Granting Privilegs to user, How? *** [message #82054] Wed, 16 April 2003 22:18 Go to next message
Robin ( Bangladesh)
Messages: 25
Registered: September 2002
Junior Member
Suppose user WORKER is DBA and has 10 tables and 20 views. STORE is a new user. How full access (insert, update,select) of WORKER's owned objects could be given to new user STORE by one or two command ?

Thanking u
ROBIN

Report message to a moderator

Re: *** Granting Privilegs to user, How? *** [message #82072 is a reply to message #82054] Fri, 18 April 2003 05:12 Go to previous message
Sun
Messages: 92
Registered: August 2002
Member
begin
for i in (select tname from tab where username = 'WORKER') loop
grant all on i.tname to store;
end loop;
end;

it should work.

Report message to a moderator

Previous Topic: can you open reports background engine from forms?
Next Topic: Forms6i - How can I create a shopping cart using forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 06 16:01:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.