1
(click on this box to dismiss)
How to grant table creation rights to a user?
I can use GRANT to give privileges on table. But how do I give privileges on database? I want give another user rights similar to these of dba.
Thanks in advance.
link
comment (0)
accepted answer
asked last year
![[Level:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 20 (0% completed for the next level)"){kind=icon}
xenu20
1
Answer
1
To give identical rights as dba, all you need to do is:
CREATE USER new_dba GROUPS dba;
In CUBRID, any user can become a group, thus granting all its privileges to its group members. Therefore, in the above case the new_dba becomes a member of dba group, thus obtains all the same rights.
Here are a few good articles for you to learn more about groups and users in CUBRID.
![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)"){kind=icon}
dbaasked last year
viewed 455 times