RE: DEFAULT ROLE ALL

2003-03-12 Thread Ramon E. Estevez
Title: Message



That 
all the roles that the user has assigned get enabled when he logs 
on.

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Edouard 
  DormidontovSent: Wednesday, March 12, 2003 8:39 AMTo: 
  Multiple recipients of list ORACLE-LSubject: DEFAULT ROLE 
  ALL
  Hi World!
  
  What this mean:
   ALTER USERusername DEFAULT ROLE ALL;
  
  Thanks
  Ed Dorma


RE: DEFAULT ROLE ALL

2003-03-12 Thread Deshpande, Kirti



That 
sets all roles assigned to the username as it's default and are in effect at the 
same time whenever username logs in.

- 
Kirti 


  -Original Message-From: Edouard Dormidontov 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 7:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  DEFAULT ROLE ALL
  Hi World!
  
  What this mean:
   ALTER USERusername DEFAULT ROLE ALL;
  
  Thanks
  Ed Dorma


RE: DEFAULT ROLE ALL

2003-03-12 Thread kirti . deshpande
That sets all roles assigned to the username as it's default and are in
effect at the same time whenever username logs in.
 
- Kirti 
 

-Original Message-
Sent: Wednesday, March 12, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L


Hi World!
 
What this mean:
ALTER USER username DEFAULT ROLE ALL;
 
Thanks
Ed Dorma

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).