-
SQL GRANT privilege to multiple tables - one or two commands? how?
GRANT INSERT ON
(I need to grant the user privileges to BOTH orders & orderline.
Do I begin:
GRANT INSERT ON orders.orderline?
OR
GRANT INSERT ON orders (orderline)?
OR
make em separate commands? or what? it is unclear. And then of course go on to TO ...blah blah blah
AND
MUST GRANT blahblahblah & TO blahblahblah BE on SEPARATE LINES? OR CAN IT ALL BE ON ONE LINE?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|