application team have requested me to allow a following permission to one of the user, actually how do we execute selective procedure below to be able to run by users ? I think sso_role will help me but again application team want something limited with sso-role ( not all permission within sso-role )
sso_role (default ON) - what is inside default ? and how do I grant only limited sso_role privileges ?
sp_addlogin_ sp_password_ sp_kill_ sp_unlocklogin_ sp_locklogin_ sp_displaylogin