Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    1

    Unanswered: Grant seelct on all objects in a schema to a user

    How to grant select on all objects in a schema to a user . I want this grant to be available on new objects that will be created in the schema ..

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    you can't. select privilege on an object number be granted to each object one at a time. You can make a script to make it easier but a new object created in the schema will not automatically have the grant.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by Bill
    . . . but a new object created in the schema will not automatically have the grant.
    Unless you have a schema trigger and you code the grant(s) there.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    true, Frankly I didn't think of that. Nice Call.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Tags for this Thread

Posting Permissions

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