What is the syntax and usage of GRANT ALL ON option?

Showing Answers 1 - 2 of 2 Answers

reena

  • Oct 22nd, 2007
 

The syntax is

grant all
on table_name
to user_name

example:
grant all
on emp
to public

usage:

it will give all previleges to public i.e. insert,delete,update,select on table emp

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions