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