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
|