SQLServer user permissions to execute Stored procedures
satya - 5/30/2017, 10:42:30 AM
SQLServer user permissions to execute Stored procedures
SQLServer user permissions to execute Stored procedures
Search for: 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
what are default roles in SQL Server like db_datawriter
Search for: what are default roles in SQL Server like db_datawriter
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
Roles for executing stored procedures in SQL Server
Search for: Roles for executing stored procedures in SQL Server
satya - 5/30/2017, 10:54:12 AM
Roles to execute stored procedures in SQL Server
Roles to execute stored procedures in SQL Server
Search for: 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
Giving execute permissions to a specific Schema in SQL Server
Search for: 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
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
varchar vs nvarchar in SQL Server
satya - 5/30/2017, 11:35:51 AM
nvarchar in stored procedures in SQL Server
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
How to change user password in SQL Server Management Studio
Search for: 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