PDA

View Full Version : Simple for some but problem for me

Jeff C
06-28-2003, 08:00 AM
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!
Sybrand Bakker
06-28-2003, 09:51 AM
On Sat, 28 Jun 2003 16:00:37 GMT, "Jeff C" <jcondon@midsouth.rr.com>
wrote:
What is the SQL command to give system SYSDBA privs in the OEM? Right now Ican only connect as normal and need the SYSDBA rights but dont trust my sqlsince 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

MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service