Post reply

how to get the databases that the current login user can visit?

  • July 1, 2006 at 11:59 pm

    #366622

    hi guys,

        how can i get the database list, using sql statements, that the current login user can vist?  i know the enterprise manager can show this list when viewing the user's properties.  

        thank u.

  • July 2, 2006 at 8:12 am

    #647117

    sp_MSdbuseraccess

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

  • July 3, 2006 at 7:04 am

    #647177

    sp_helprotect null, 'User_Name'

    Roi Assa

    Kindest Regards,

    Roi Assa

  • July 3, 2006 at 7:49 am

    #647181

    sp_MShasdbaccess

  • July 3, 2006 at 9:52 am

    #647254

    thank you all,

    to Johnson, sp_mshasdbaccess works well.

    to  Roi Assa , sp_helprotect null, 'User_Name' lists all the current user's rights in the current database,

    to stax88, sp_MSdbuseraccess not exist, maybe you mean sp_mshasdbaccess?

     

  • July 3, 2006 at 1:43 pm

    #647278

    Sorry, I'm using v9.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

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

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