I have a SQL Server default instance using SQL Server Authentication and two users, User1 and User2.
User1 has the public server role while User2 has the public server role + sysadmin server role.
I have created one database, sptest1. Inside that database I have created a stored procedure,
sp_viewtbl and also created a schema. Using the schema I have disabled executing stored procedure for User1 and it works.
How can I deny executing the stored procedure by User2, who has sysadmin server role?
Suppose I have created User3 and given permissions as sysadmin and public.
So how can I prevent that new user from executing that same stored procedure? I have to secure
sp_viewtbl from others login even if they have sysadmin permission.