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

Home -> Community -> Usenet -> c.d.o.server -> DBA user, and rights on another user's schema

DBA user, and rights on another user's schema

From: Vik <viklall_at_my-deja.com>
Date: 2000/07/20
Message-ID: <8l7i1f$2a9$1@nnrp1.deja.com>#1/1

I have three users in my database. A DBA account which I want to have all possible privileges, and two users that the DBA account creates.

User 1 goes on to create some tables and indexes.

I want (as DBA) to be able to grant access to User 2, to be able to read User 1's tables via select rights (and some synonyms).

I can grant these as User 1, over to User 2.

Shouldnt I also be able to do this as the DBA?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

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