General discussion

Locked

mysql role

By mit ·
how can i implement role (new role apart from what mysql has) like what in oracle.
would it be any way i can create new role and asign basis role of mysql to this new role
thanks

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

mysql role

by NetMan_OVO In reply to mysql role

Use GRANT Syntax:

GRANT privelage_type
[(column_list)] [, privelage_type [(column_list)]...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']

privelage_type are
CREATE
DELETE
DROP
ALTER
UPDATESee the Manual for more detail

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums