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 on
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 No
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 at
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 which
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
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,
Se
dba_role_privs
> "Daiminger, Helmut" 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. He
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 d
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
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
--
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
Sent by: Subject: 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
-
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
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!
Title: Find DBA users
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
16 matches
Mail list logo
