Grant permissions to SQL Server 2005

Question

Iam working in ruby on rails for fetching existing tables from remote MS Sql database.Iam getting this error while trying to run the application.

ODBC::Error: 42000 (229) [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'TeviceDetails', database 'BObd', schema 'dbo'.: EXEC sp_executesql N'SELECT [TeviceDetails].* FROM [TeviceDetails]'

From forums and other sites i understand this is due to 'permission denied from server DB' and mentioned several solutions to rectify this.following are the solutions i got from forums.

But my problem is, i really don't know where to type/grant these privileges. (Is it in ruby console or ODBC console.If it is in ODBC console ,from where i can access this ODBC console??)

USE msdb

CREATE USER [TheUser] FOR LOGIN [TheLogin]
GO

GRANT EXECUTE ON sp_start_job TO [TheUser]
GO

 SQLAgentUserRole
 SQLAgentReaderRole
 SQLAgentOperatorRole

score 0 · Accepted Answer · answered Mar 08 '13 at 05:14

The easiest place to do that is in SQL Server Management Studio, or SSMS. It's a free download from Microsoft.

http://www.microsoft.com/en-us/download/details.aspx?id=8961

You could type these into an ODBC console but you may as well get the proper tool for the job.

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

Please read this answer.

TSQL to grant db_datareader and db_datawriter for MS SQL Server

You can execute this once for the database.

edited May 23 '17 at 12:21

Community

1
1

answered Mar 08 '13 at 05:28

Akalanka

310
5
12

Grant permissions to SQL Server 2005

2 Answers2