Results 1 to 2 of 2

Thread: Permissions

  1. 12-02-2009, 11:25 AM #1
    mauricio
    mauricio is offline Registered User
    Join Date
    Dec 2009
    Posts
    1

    Smile Permissions

    Hello!!!

    How can i script a permission to Create, Drop or alter Databases and Objects inside the databases, such as Tables, Functions, Views, procedures, etc...?

    I also want to say that my objective is find a free way to grant permissions Instead of use Fixed Database Roles.


    thanks.


    Mauricio
    Reply With Quote Reply With Quote
  2. 12-02-2009, 12:51 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Then you have to trace each of those processes to find out which system sp/function envolved then grant permission on them. But sql granted permission on certain objects to fixed role and will check permission inside the object when call it, you can't bypass that check.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules