satya - 5/30/2017, 10:42:30 AM

SQLServer user permissions to execute Stored procedures

satya - 5/30/2017, 10:48:38 AM

what are default roles in SQL Server like db_datawriter

satya - 5/30/2017, 10:49:55 AM

These roles are documented here

satya - 5/30/2017, 10:50:36 AM

couple of key ones


db_datareader
db_datawriter

//Sparingly use
db_owner

satya - 5/30/2017, 10:51:34 AM

Roles for executing stored procedures in SQL Server

satya - 5/30/2017, 10:54:12 AM

Roles to execute stored procedures in SQL Server

satya - 5/30/2017, 11:04:41 AM

Adding a role from SQLMatters website

satya - 5/30/2017, 11:05:04 AM

Giving execute permissions to a specific Schema in SQL Server

satya - 5/30/2017, 11:05:18 AM

What is dbo schema in SQL Server

satya - 5/30/2017, 11:10:12 AM

Basic idea


CREATE ROLE db_executor
GRANT EXECUTE ON SCHEMA::schema_name TO db_executor
exec sp_addrolemember 'db_executor', 'Username'

satya - 5/30/2017, 11:35:10 AM

varchar vs nvarchar in SQL Server

satya - 5/30/2017, 11:35:51 AM

nvarchar in stored procedures in SQL Server

satya - 6/19/2017, 1:31:19 PM

How to change user password in SQL Server Management Studio

satya - 6/19/2017, 1:34:40 PM

Oh, it is not under database/users but in logins


/open
 /security
  /logins
   /user
    /specify password