grant execute on sp_server_info

• sedj

  SSC Veteran

  Points: 216

  More actions

  July 13, 2010 at 5:49 am

  #145865

  I've created a new role and a new user which resides in this new role.

  When i try to run:

  GRANT EXECUTE On [sys].[sp_server_info] TO [DATABASE].[db_role]

  i receive the following error:

  Msg 4629, Level 16, State 10, Line 1

  Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.

  And if i try to run the same query in the master database i get the following:

  Msg 15151, Level 16, State 1, Line 1

  Cannot find the user 'db_role', because it does not exist or you do not have permission.

  Anyone have any ideas?

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  July 13, 2010 at 5:39 pm

  #1192427

  The role has to be created in master database.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  July 13, 2010 at 5:50 pm

  #1192432

  Create the Role in the Master and then grant the permission.

  Thank You,

  Best Regards,

  SQLBuddy