Creating New DBA technology
Home Features Presentations Download Purchase Contacts
Presentations
 
Presentations > Creation or modification of database users

Pick a user and select the Alter User (Create User) item from the context or Security menu.

 

 

  

If there is no active (unfinished) SQL task, create a definition (description) of an SQL task, specify it options and the user whose privileges will be used for running this task. If necessary, you can specify the launch window - the task doesn't start automatically by default.

Use the creation/modification dialog to specify the necessary parameters, add a description of the user, attach a document, if necessary, and press OK.

All SQL expressions required for this process have been generated. If need be, you can view and edit them in the SQL task node.

Note that the users’ passwords are automatically stored in the system repository in an encrypted form, and that the SQL expressions only contain hash values.
 

 
www.dbaeasy.com   Copyright © DBA Inventions Ltd. 2008 All Rights Reserved.