Results 1 to 3 of 3

Thread: dynamic script

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Unanswered: dynamic script

    how can I grant select on all tables to new user with a dynamic script in sybase?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    why don't you instead create a db_reader role that basically has SELECT against all the tables and the policy should be any new object that gets created would have SELECT for db_reader.

    All the users by default should at least belong to db_reader.

  3. #3
    Join Date
    Mar 2007
    Posts
    2
    there is nothing in sybase, that I can see, that allow me to create roles

Posting Permissions

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