#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0

    Grant role to multiple tables and procedure


    Hello,

    Can you please help me to grant a role on multiple tables and procedures with only select privilege in one time ?
    I mean is there any source code to do that ?
    It 's too hard for me to grant a role line by line for about 50 tables and 80 procedures.
    Thanks for helping me.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0
    As I am new in this forum I did not found for editing my previous post. So I add this post to mention that I am with Firebird 3 and UIB

IMN logo majestic logo threadwatch logo seochat tools logo