contents.gifindex.gifprev1.gifnext1.gif

Oracle: Setting Up a User Account

Acu4GL for Oracle must be able to connect to a user account. You may either set up one general account for all users, or an account for each individual user. In order to set up an account, you must have Database Administrator (DBA) privileges.

You may set up either of two types of logins to Oracle:

Automatic login

Automatic login means that the connection to Oracle is based on the user's computer login. The SQL command to establish automatic login looks like:

GRANT CONNECT, RESOURCE TO OPS$user-name IDENTIFIED BY password

user-name should be the same name that will be used to log in to the system.

Configured login

If you want to specify a database login name other than the system login name, you can use Configured login. The SQL command syntax to enroll a new user by configured login is:

GRANT CONNECT, RESOURCE TO db_login_name IDENTIFIED BY password

db_login_name is the name you want to use to log in to the database.

For more details on login, see your site's system administrator and the Oracle Database Administrator's Guide.