RE: Find DBA users

Title: Find DBA users Try select grantee from dba_role_privs where granted_role = 'DBA' John -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: 26 November 2001 12:10To: Multiple recipients of list ORACLE-LSubject: Find DBA users Hi! Is there a

Re: Find DBA users

Hi, Select grantee, granted_role from dba_role_privs where granted_role = 'DBA'; Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 26-11-2001 13:10:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Find DBA users

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA'; JP On Mon 26. November 2001 13:10, you wrote: Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut

Re: Find DBA users

select * from dba_role_privs where granted_role = 'DBA'; Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/

RE: Find DBA users

Helmut, Try DBA_ROLE_PRIVS: select * from DBA_ROLE_PRIVS where granted_role = 'DBA'; HTH Mark -Original Message- Helmut Sent: 26 November 2001 12:10 To: Multiple recipients of list ORACLE-L Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA

Re: Find DBA users

Check view dba_sys_privs Mujeeb Chowdhry [EMAIL PROTECTED] 11/26/01 07:10AM Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Find DBA users

Title: Find DBA users select grantee from dba_role_privs where granted_role = 'DBA'; Dave -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Monday, November 26, 2001 6:10 AMTo: Multiple recipients of list ORACLE-LSubject: Find DBA users Hi! Is

RE: Find DBA users

Title: RE: Find DBA users [EMAIL PROTECTED] select grantee from dba_role_privs where granted_role='DBA'; GRANTEE -- SCOTT SYS SYSTEM [EMAIL PROTECTED] grant dba to nirmal; Grant succeeded. [EMAIL PROTECTED] select grantee from dba_role_privs where

RE: Find DBA users

Damn! And we were just talking about this earlier Jack!! You got there before me, but I already sent one off!! :) Hey - at least mine is at least a *little* different :P -Original Message- [EMAIL PROTECTED] Sent: 26 November 2001 13:25 To: Multiple recipients of list ORACLE-L Hi,

Re: Find DBA users

Helmut, Since you know enough to ask if there is a data dictionary view, might I suggest you also spend some time reviewing the reference manual which contains a list of all the data dictionary views and what information they contain? just a thought, people seem to have been in a good mood this

RE: Find DBA users

Or get one of those big posters -Original Message- Sent: Monday, November 26, 2001 7:15 AM To: Multiple recipients of list ORACLE-L Helmut, Since you know enough to ask if there is a data dictionary view, might I suggest you also spend some time reviewing the reference manual

RE: Find DBA users

Hi, My databases are running smooth, Euro testing is almost finished. I do have time to read my list-mail from the list :-). Playing around with Norad at the moment. My alerts should be sent to my mailbox i.s.o my website !! but this PC only has internet through the lan and no e-mail or modem

Re: Find DBA users

Try : select grantee from dba_role_privs where granted_role = 'DBA' From: Daiminger, Helmut [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Find DBA users Date: Mon, 26 Nov 2001 04:10:24 -0800 Hi! Is there a data dictionary

RE: Find DBA users

Do you have an SMTP server that you can forward the alerts to? You could forward the alerts over your LAN to the mail server, to then forward to your internet email account? Have you tried using the EMAIL_USING_SMTP action? Another option is to install a server agent (if you don't already have