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 -> Default Privileges

Default Privileges

From: kirtan <kirtan.acharya_at_gmail.com>
Date: 9 Mar 2005 22:49:15 -0800
Message-ID: <1110437355.683229.257280@g14g2000cwa.googlegroups.com>


Lets say the following steps take place :-

  1. The DBA creates a user(NEWUSER), and grants him CREATE SESSION privilege.
  2. The DBA creates a table in NEWUSER's schema.
  3. NEWUSER logs into the database and is able to insert a few rows, updates them and delete them.

Why is this so?

Is it because NEWUSER owns the table?

What are the default privileges (if any) whcih are given to a newly created user?

Thanks in advance,
kirtan Received on Thu Mar 10 2005 - 00:49:15 CST

Original text of this message

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