Post reply

User unable to see Logins after recreation of permissions in new instance

  • March 2, 2021 at 7:27 am

    #3852102

    Hello All

    I was tasked with setting up a new instance on the same server, but with a higher version (from 2012 to 2016).

    User would like to test higher version before moving dbs there.

    After installation I recreated all the logins using these guidelines - https://www.sqlshack.com/move-or-copy-sql-logins-with-assigning-roles-and-permissions/

    User confirmed successful login, but one thing that's different already is that they cannot see all Logins from Security folder in a new one. What am I missing there?

    KR,

    John

  • March 3, 2021 at 8:10 am

    #3852733

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • March 3, 2021 at 9:24 am

    #3852749

    Okay I found out that I was missing - server wide securables.

    For anyone with same problem you can either check it directly from SSMS in Instance > Security > Logins > Login Properties > Securable or through this query

    SELECT l.name as grantee_name, p.state_desc, p.permission_name

     

    FROM sys.server_permissions AS p JOIN sys.server_principals AS l

     

    ON   p.grantee_principal_id = l.principal_id

Viewing 3 posts - 1 through 3 (of 3 total)

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