Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Granting privileges


    Is there a way of granting a privilege across all objects (tables, functions, triggers, views, sequences, etc.) within a database from a single GRANT statment, or must I issue a GRANT on each table (view, sequence, etc.)?


  2. #2
    Join Date
    Jan 2004

    Re: Granting privileges

    I think that you must grant every tables but there are better ways than writing everything.

    If you have many users to grant you can create groups and apply permisions to the groups.

    To avoid writing a lot, just make a query to retrieve all the tables. So you can make a select like this:

    select 'grant select, insert, update, delete, rule on ' + systable.nobre + ' to ' + usuario
    from systable

Posting Permissions

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