4 thoughts on “SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master

  1. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

    Alanna

  2. I’m using the following SQL commend but got the error saying “can not find the login”. I’m using the windows AD group login.

    USE master;
    GRANT VIEW ANY DEFINITION TO [PRCINS\SQL_READ_AgencyDataRepository_NJ_Model]
    GO

    Error:
    Msg 15151, Level 16, State 1, Line 2
    Cannot find the login ‘PRCINS\SQL_READ_AgencyDataRepository_NJ_Model’, because it does not exist or you do not have permission.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s