You can translate the question and the replies:

Admin question

How do you alter existing user to make him admin. an example please.
user
06-01-2022 17:12:47 -0500

3 Answers

Hi, You can alter an existing user and assign roles like serveradmin to the normal user (which is almost equivalent to being an administrator user of Virtual DataPort). It can be done either graphically or through VQL commands. In order to assign it in graphically, I would perform it with below steps: * Open the Virtual DataPort Administration Tool. * Navigate to the Administration>User Management. * Select the User>Assign Roles. * Choose the **serveradmin** role. To modify the role of normal user through VQL commands, I would execute the below command in VQL shell: ``` “ALTER user <user_name> grant role serveradmin” ``` For more information,you can take a look at the “[User and Access Right in Virtual DataPort”](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#types-of-access-rights)section under Virtual DataPort Administration Guide Additionally you can also refer to the [ Modifying User Data section](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/creating_databases_users_roles_and_access_privileges/managing_users/modifying_and_deleting_users#modifying-user-data) under the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
07-01-2022 04:14:28 -0500
if the user is granted serveradmin , does he gets access to all denodo componenets?
user
12-01-2022 15:03:16 -0500
Hi, Normal user who has been assigned with the role** serveradmin** could access different components and perform activities like managing databases, changing different settings of the Server, etc.in the Virtual DataPort server. Further, there are other predefined roles available for different tools like Data Catalog,Diagnostic and Monitoring etc. Based on the operation to be performed you could assign the required roles to the user. For more information about the roles, you can take a look at the[ “Default Roles”](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#default-roles)section under Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
13-01-2022 07:03:03 -0500
You must sign in to add an answer. If you do not have an account, you can register here