In the Grants pane of the Modify dialog, click the Add button ( ). In the Database Explorer ( View | Tool Windows | Database Explorer), right-click a user or a role and select Modify Role. To do that, open the Modify dialog for the object and use the Grants pane. You can grant a user and a role permissions for database objects.įor other database objects, you can configure the permissions that each grantee has for the object, and the list of grantees. In the Preview pane, you can view and change the generated SQL code. ![]() Select and specify the necessary database settings. In the Create dialog that opens, enter the name of your user or role in the Name field. In this case, you must expand the data source tree to the database node, right-click the database node and select New | User or New | Role. In the Database Explorer ( View | Tool Windows | Database Explorer), right-click a data source node and navigate to New | User or New | Role.įor some databases, you need to specify a database where you want to create a role or a user. You can see a reference on node and object icons in the Data sources and their elements chapter of Database Explorer topic. ![]() Users and roles can be seen in the Database Explorer. Consult with the documentation of your database vendor for the settings list and what type of concept the database uses for access control. Settings in the Create and Modify dialogs vary depending on the database vendor. In some databases, a role can be a user that has the login right. Both of them are used for access control and define a set of permissions. ![]() Different databases use concepts of users and roles to manage the permissions in your databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |