Post reply

RESTRICTED_USER

  • September 12, 2005 at 12:16 pm

    #91180

    Does someone has the query to find out all the RESTRICTED_USER for a given database.

     

     

     

    Kindest Regards,

    Amit Lohia

  • September 12, 2005 at 3:24 pm

    #589188

    Not sure exactly what you mean?

    RESTRICTED_USED is a Property of a Database. When the DB is set as RESTRICTED_USER, only sysadmin,dbcreator and db_owner have access to it!

    hth

     


    * Noel

  • September 12, 2005 at 3:36 pm

    #589194

    yeah I know that. What I meant was if someone has a query which will return all the users which are member of sysadmin,dbcreator and db_owner.

     

    Kindest Regards,

    Amit Lohia

  • September 12, 2005 at 3:49 pm

    #589200

    exec sp_helprolemember @rolename = 'db_owner'

    exec sp_helpsrvrolmember @srvrolename ='sysadmin'

    exec sp_helpsrvrolmember @srvrolename ='dbcreator'

     


    * Noel

  • September 12, 2005 at 4:21 pm

    #589206

    thank you. now I can customize them

    Kindest Regards,

    Amit Lohia

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply