Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove sysdba privilege for user

user1980Apr 19 2007 — edited Apr 19 2007

Hi,

$ sqlplus

SQL*Plus: Release 9.2.0.7.0 - Production on Thu Apr 19 05:57:41 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Release 9.2.0.7.0 - 64bit Production
JServer Release 9.2.0.7.0 - Production

SQL> exit
Disconnected from Oracle9i Release 9.2.0.7.0 - 64bit Production
JServer Release 9.2.0.7.0 - Production
$
$
$ id
uid=5000(webman) gid=103(wbroot)
$

I want to remove "sysdba" connect privilege for user "webman", what do I need to do?
I am on HPUX
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2007

Added on Apr 19 2007

#general-database-discussions

9 comments

8,299 views