Which user has sysdba




















Having troubles listing users with DBA role on your system? Want some help finding the necessary privileges? Need some help with the setup of the Oracle Capture Privilege feature? Our experts are here to help you. Want to go a step further and know how to increase security on your system?

You can use the Database Manager or a suitable query tool to display or change the DBM operator properties, server authorizations and SQL user properties of the database system administrator. Users, Authentication and Authorizations.

Conventions for User Names and Passwords. DBM Operator Properties General Description Name Name of the database system administrator Password Password of the database system administrator Comment Description of the database system administrator Disabled Specifies whether the user account of the database system administrator is locked Enable Pwd You can define a second password for the database system administrator.

Server Authorizations Server authorizations server rights are authorizations for the DBM Server program and thereby for executing actions in the Database Manager see the list of server authorizations for the DBM Server. Setting the timeout value. Typically these can be set when the Oracle software is installed.

This functionality has not been implemented on Unix See bug Disabling Operating System Authentication Given the above information about the technical implementation details of OS authenication it is possible to disable OS authentication by putting non-existant OS group names in the config. Unfortunately it is also common for the root users' primary group to be the group 'daemon' which may prevent it from being allowed to connect without a password.

Domain prefixed usernames It is possible to set up usernames which include the domain as a prefix to the username.

This is described in detail in Note Google "Charles Hooper Burleson" and you'll see what I mean. Charles Hooper is IMHO one of the world's top experts on Oracle and I would respect his opinion and I don't think he made the effort to put up what he has done if he didn't feel it was worth the effort to point out Burleson's ahem For example; grant select on SYS.

On the import? RDFozz Bobby Durrett Bobby Durrett 1 1 silver badge 8 8 bronze badges. Trying to answer the real question. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password.



0コメント