SQL Server - Access to database as Read only
Asked By Naresh Kumar on 14-Dec-11 01:57 AM
I need to give permissions to the users for the SQL server database. They need to connect to the server and can see all the tables and also select the data from the tables.
But they don't insert , alter or delete the data in the tables. Also , should not provide the permissions to view the Stored Procedures, Functions and Views.
Reena Jain replied to Naresh Kumar on 14-Dec-11 03:00 AM
Resolution: Grant rights to the administrator. Follow these steps:
Go to Start > All Programs > Microsoft SQL Server 2005 >
Configuration Tools > SQL Server Surface Area Configuration.
Step 2: Click on 'Add New Administrator'.
In the 'SQL Server User Provisioning on Vista' dialog box, look out for
the 'Member of the SqlServer SysAdmin role ' in the 'Available
Privileges' box. Transfer it to the 'Privileges that will be granted to'
box. Click Ok.
If you right click "SQL Server Management Studio" and choose "Run as
Administrator" it will allow you to create new databases also and make
sure that you create a "dedicated windows account" as service
account and give this account "securityadmin server role" and "dbcreator
server role" membership. Start menu > Right Click Computer and choose
"manage" > Local Users and groups > right click users and choose
Note: You will be able to see 'Add New Administrator' in the Configuration tool only if you have logged in as an administrator
hope this will help you