Database Software

Hello

Please can someone tell me how I can create a user account which has full access to its own schema and read-only access to a different schema.

I created a new user which also created an associated schema but looking at the roles it seems I have to give the account the select any table, update any table, drop any table, etc system privileges but this also applies it to other schemas giving full access to the schema.

I did see the option to assign permissions to each table individually which may have worked but as there are hundreds of tables I would rather not have to go down that route!

Or do I need to create a new role which has the required access? I did try this but still wasn't sure what I needed to do to assign only one of the schemas to the account.

I did try Googling for the answer but couldn't quite work it out.

The user that created the new user can access the objects in the new schema using NEWUSER.table which I wanted but I just don't want NEWUSER to have anymore that read access to objects in the other schema but whilst retaining full access to all current and future objects in its own schema.

Thanks
Robin

Edited by: user10592251 on 18-Feb-2011 16:55