-
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
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
|