Shulou(Shulou.com)06/01 Report--

Role Management of Dameng Database

Role management is rarely used in daily situations. In general, roles included in major databases can be configured according to the various needs of some users or some tables. This article also follows the previous idea to do practical operations on the basic functions such as role creation, modification, deletion, and add permissions to the corner, such as creating tables, and testing permissions.

1. View all roles

Select * from dba_roles

2. Create a role

Next, we create

Create role role1

Create a tab1 table for a test

3. Add permissions to roles

Let's first assign permissions to the query table to this role and assign them to test1 users to do a test.

Assign query table tab1 permissions: grant select on tab1 to role1

Assign create table permissions: grant create table to role1

Assign roles to test1 users: grant role1 to test1

The following screenshot shows the effect before and after assigning permissions after logging in with test1 users.

Test query table tab1:select * from sysdba.tab1

Test creation table tab2:create table tab2 (id int, name varchar (40))

4. Delete a role

The command to delete a role is the same as the command to delete other objects

Drop role role1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.