-
Hi,
Here i have 2 questions -
1) how do i grant privilages like select, delete, update, insert to user b on user a schema.
suppose if i have 1500 tables then i should give all the permissions to the user 'b' of only user 'a' schemas with out generating a script.
for ex:
select ' grant ' .......
here if u do like this there will be a problem.
if u create a new table then explicitly we need to give the permissions.
Can some one tell me at one shot how we can grant the privileges.
2) Yesterday i have created a database user by giving
default tablespace and temporary tablespace . I was getting error and if i mention quota then it is working. I don't know the reason why it is getting error if i don't mentioned the quota. the default is unlimited so it should not thow any error.
Cheers
sanjay
san
-
1) You can not grant rights to another user's object in 7x or 8x, it is possible in 9i!
2) Need the error if you can get it.
Doug
-
Logon as a and generate the script using,
select 'grant select,update,delete, insert on '||table_name||' to b;'
from USER_TABLES;
now run this script while logged on as a.
Better create role and grant these permissions to role and then grant this role to user b or anyone else as required.
-
Originally posted by molonede
1) You can not grant rights to another user's object in 7x or 8x, it is possible in 9i!
This has nothing to do with 9i - granting privileges on another user's objects is available at least since Oracle 6.0!
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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
|
Click Here to Expand Forum to Full Width
|