Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    33

    Unanswered: Read only privledges on a database

    Hi All,

    Is der anyway of granting select privledge to schema.My database contains many tables and i need to grant select privledge to a user who want to run reports.
    o
    r
    Will "grant select on tab1,tab1..list to user1,user2", I mean granting select privledges to multi-tables at a time supported in IDS-7.3
    Any assistance is greatly appreciated...

    Thanks
    Mallik

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    try something like this:

    select "grant select on "|| tabname || " to user user1;"
    from systables where tabid>99

    And output from this sql run as sqlscript.

Posting Permissions

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