Re: Simple for some but problem for me
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 28 Jun 2003 19:51:37 +0200
Message-ID: <qalrfvgp0anhsvaasjcndes2ss2iq9jvb9_at_4ax.com>
Date: Sat, 28 Jun 2003 19:51:37 +0200
Message-ID: <qalrfvgp0anhsvaasjcndes2ss2iq9jvb9_at_4ax.com>
On Sat, 28 Jun 2003 16:00:37 GMT, "Jeff C" <jcondon_at_midsouth.rr.com> wrote:
>What is the SQL command to give system SYSDBA privs in the OEM? Right now I
>can only connect as normal and need the SYSDBA rights but dont trust my sql
>since its been almost 5 years since I have had to do any. TIA!
>
grant sysdba to <user>
There are several precautions though:
the user granting the priv must have been connected as SYSDBA
remote_login_password_file must be exclusive
simple RTFM issue.
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Jun 28 2003 - 19:51:37 CEST