Results 1 to 7 of 7

Thread: SQL GRANT privilege to multiple tables - one or two commands? how?

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    A GRANT statement is applicable to one object at a time, so you have to run two GRANTs for two tables.

  2. #2
    Join Date
    Jun 2013
    Posts
    4
    So does this seem to make sense below, since orders is really one table & orderline is a sep one?:

    GRANT INSERT ON orders to Smith, Jones
    OR
    GRANT INSERT ON orderline to Smith, Jones

    thanks!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •