Complete Newbie pleads for help

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

Complete Newbie pleads for help

Author

Topic

MadBadAndUglyToo
Starting Member

3 Posts

Posted - 2010-03-17 : 14:50:18

Never had to administer SQLServer before - happy with Oracle but don't what I am doing in SQL Server.

To create a method of accessing an existing db which can only hit one table (for reporting), I have done the following:

Created a new login account & password (am using SQL authentication)
Created a new user
Assigned "select" grant on the table to that user
Attached the user to the login account.

I was expecting the permission on the table to bubble up through the user-login relationship and allow the login account (and any application using that login account) to "see" the table, but that's not happening.

No doubt you are laughing your socks off at my stupidity , but any help would be superb.

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2010-03-17 : 15:45:33

Right click on userName ->properties

Click on General - check mapping user-login

Click on Securables - check securables and permission table-user

If correct, then it's supposed to work

MadBadAndUglyToo
Starting Member

3 Posts

Posted - 2010-03-17 : 16:07:01

Namman:

Thanks v. much for the reply.

Securables on the user are empty, but the permissions form on the table's properties show the user's permissions as I want - the "Effective Permissions" comes up empty though.

namman
Constraint Violating Yak Guru

285 Posts

Posted - 2010-03-17 : 16:35:02

Securables on the user are empty

Then, from Securables, click Add -> Object Types -> check Tables ->Browse -> select your table.

On Explicit Permission, check Select on Grant.

I did a test and it works fine for me.

MadBadAndUglyToo
Starting Member

3 Posts

Posted - 2010-03-17 : 17:08:17

Namman:

Thanks for the reply

Did just that when doing the -->Assigned "select" grant on the table to that user<-- in the original post.

Executing "select * from information_schema.table_privileges" shows that the db knows about the priv's, and indeed doing [Securables, click Add -> Object Types -> check Tables ->Browse -> select your table] from your suggestion pops the priv's already entered onto the Explicit details form.

Ignoring the forms and doing the job through T-SQL seems not to have achieved anything different.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources