User Security settings Excel Connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

User Security settings Excel Connection

Author

Topic

blund
Starting Member

23 Posts

Posted - 2012-02-06 : 14:47:45

I am trying to give some permission for SQL data access to a few individuals.
I have created a View, with only certain bits of information from select tables and columns.
They need to only access the (read only) SQL data thru Excel, via a SQL connection.
This is what I have done currently, which seems to be working:

1)Added user to Security/Logins
2)Via: User Login/Properties/User Mapping
3)Selected specific database
4)Selected role membership: Db_datareader

Is this the proper method, with out giving undue security rights?

Let me know if you need more details,
Thank you,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-06 : 15:07:43

Yes. That is exactly what I would do. Although if you know what tables/views they need, I would instead grant SELECT on those only. I normally don't know exactly what is needed, so a database role is ideal for me.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

blund
Starting Member

23 Posts

Posted - 2012-02-06 : 16:39:47

Lets just call it a lucky guess on my part.

Thank you for the confirmation.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources