none
Find out what permission

    Domanda

  • Hi Team,

    Today morning one of the user i have given some permissions datareader etc..

    How can we find out xxx user what permissions & What Roles  he owns

    How can we check please suggest me.

    I have tried in this way.

    SELECT
     SDP.PRINCIPAL_ID AS [Principal ID],
     SDP.NAME AS UserName,
     SDP.TYPE_DESC AS UserType, 
     SSP.NAME AS LoginName,
     SSP.TYPE_DESC AS LoginType
    FROM sys.database_principals SDP
    INNER JOIN sys.server_principals SSP
    ON SDP.PRINCIPAL_ID = SSP.PRINCIPAL_ID
    GO

    o/p:

    6 xxxx SQL_USER setupadmin SERVER_ROLE

    Today i have give access abc database as data_reader, i have seen in user--> property--> usermappings --database name here it is not showing any thing.

    I have checked that user account is connecting to the server after that

    click the database it is giving errror

    The database AdminMig is not accessible. (ObjectExplorer)

    Tx


    subu


    • Modificato subu999 venerdì 2 marzo 2012 14:35
    venerdì 2 marzo 2012 14:23

Risposte

Tutte le risposte