Previous Topic

Book Contents

Book Index

Next Topic

S2: Create a database user generating the authorization data

This step creates the database user termed 'Gen User' in Method1 description.

2A: Create a new DB user

  • Logon to a database tool as a database user with rights to create a new users.
  • Create and remember the name and password for the new user (eg. 'Gen_User' / 'PSW').
  • In your database tool, run the following SQL statement (substitute 'Gen_User' and 'PSW' with your user and password):

create user Gen_User identified by PSW

2B: Grant rights to the user

  • Run SQL statement (substitute 'Gen_User' with your user)

grant connect to Gen_User

  • Make sure that you are logged on as the owner of the VM database objects.
  • Run SQL statement (substitute 'Gen_User' with your user)

grant delete, insert on AMT_INFO to Gen_User

See Also

M1: Rights Provided Via Encrypted Database Role

S1: Create a database role with a full set of rights

S3: Create a database user with limited set of rights

S4: Generate the authorization data

Notes and Recommendations