Second user with the same privileges

Hi!

We are having one schema (e.g. SCOTT) that holds all the objects for our application.

What would be the best way to create another user (e.g. MIKE) who has acces to all tables und procedures that SCOTT owns? In other words: MIKE should have the same rights to the objects than SCOTT.

Do I have to grant select, insert, update and delete on every table to MIKE or is there a better way to do it?

Thanks, Received on Fri Sep 15 2000 - 20:05:56 CDT