Web Development

Ask something
Discussion Locked

mysql role

0 helpful
1 reply

by mit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by rakeshkanojia

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

This discussion is closed to new replies.