By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,333 Members | 1,843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,333 IT Pros & Developers. It's quick & easy.

How to give a grant like select,update,insert on a single table

P: 1
How to give a grant like select,update,insert on a single table

i had tried with the command grant eg:GRANT SELECT,INSERT,UPDATE
ON DTS_OUTBOX_QUEUE
TO sanpapps@dap1
IDENTIFIED BY 'disable';

where snapapps is the user name and dap1 is hostname.

when i tried this its gving error incorrect table name.

plz help me out with the command.
Jun 27 '07 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
please try this

Expand|Select|Wrap|Line Numbers
  1. grant select,insert,update,delete on tablename to useraname [with grant options];
Jun 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.