Posted by: pyaradeshbasiharu October 11, 2009
Login in to Rate this Post:
0 
? 
?
use ,
Create role all_test;-Create a Role called all_test
GRANT ALL on author to all_test; -Grant all Privileges to this Role i.e all_test
GRANT all_test to AMARTIN;-Assign all_test role to amartin
if this doesn't work try
grant all on author to all_test with grant option;
or
grant all on author to all_test with admin option;