Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Second user with the same privileges

Second user with the same privileges

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Fri, 15 Sep 2000 18:05:56 -0700
Message-Id: <10620.117189@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US