Read only access to user tables

Question

Read only access to user tables

akennedy

Mr or Mrs. 500

Points: 579
More actions
April 20, 2004 at 3:17 am

#84897

I have an accounting application that I wish to query through excel VBA using NT Authentication. I have an NT group that I have given public and datareader permissions to. I have given select privrledges to the various tables. However when the users try to run the excel macro they are denied access - login denied. Does the sql services need to be stopped and started again for changes to users/roles to take effect or what priveledges must be given for this to work?
Many thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

no.

are the nt-users domain-users ? logged on to the right domain ? member of the correct nt-group ? within the correct dns ?

check the vba-connectionstring.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

akennedy Mr or Mrs. 500 Points: 579 More actions · Answer 2

They are members of the domain - we only have one domain and yes they are members of the security group

VBA connection string as follows

'Use the SQL Server OLE DB Provider.

strConn = "PROVIDER=SQLOLEDB;"

'Connect to the accounts database on the Prodn server.

strConn = strConn & "DATA SOURCE="

strConn = strConn & strInstance

strConn = strConn & ";INITIAL CATALOG="

strConn = strConn & Sheet3.Range("B2") & ";"

'Use an integrated login.

strConn = strConn & " INTEGRATED SECURITY=sspi;"

'Now open the connection.

cnPubs.Open strConn

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Are they members of any other group that would have been denied access?

K. Brian Kelley
@kbriankelley

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

don't know if it helps...

strConn = strConn & " INTEGRATED SECURITY='sspi';"

quotes added