| Re: Roles/privileges [message #50463] |
Sun, 17 March 2002 19:30 |
Anil
Messages: 80
Registered: September 2001
|
Member |
|
|
// You first create a role like this
CREATE ROLE Select_update_delete_all
// Then Grant privileges to taht Role
GRant Create table, Select any table, update any table, delete any table to Select_update_delete_all
// Then Privileges now garnted to the perticular role
// Now thsi role has to be circulated to all users
test1,test2,test3
so
grant Select_update_delete_all to test1,test2,test3.......
//
this is exactly answer to ur question
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
