The SELECT permission was denied on the object 'ta

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

SQL Server 2008 Forums

SQL Server Administration (2008)

The SELECT permission was denied on the object 'ta

Author

Topic

mary_itohan
Posting Yak Master

191 Posts

Posted - 2011-12-16 : 08:34:19

hello guys
i created a user who has a default permission of public and right clicked the user and added his select tables to his permissions list

however when i run a select * from tablename I get this error

Msg 229, Level 14, State 5, Line 1
The SELECT permission was denied on the object 'table', database 'table', schema 'dbo'.

whats wrong ?

thanks

MI

_____________________

Yes O !

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-12-16 : 09:26:58

does it work if you run select * from dbo.tablename ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-16 : 09:32:58

you need to grant access to table using GRANT t-sql statement

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

X002548
Not Just a Number

15586 Posts

Posted - 2011-12-16 : 10:43:12

GRANT SELECT ON [dbo].[table] TO [Role]

Place the user in a role and inherit permissions

makes your life easier

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

mary_itohan
Posting Yak Master

191 Posts

Posted - 2011-12-16 : 11:29:17

Yes i did, grant select permission.

Both with t sql and when i try graphically its checked.

grant select on [table] to [user_name]

Command(s) completed successfully.

_____________________

Yes O !

Sachin.Nand

2937 Posts

Posted - 2011-12-17 : 07:37:05

Did you try giving permission on schema to the user ?

Grant Select on Schema::[dbo] to [user]

PBUH

mary_itohan
Posting Yak Master

191 Posts

Posted - 2011-12-17 : 08:09:33

quote:
Originally posted by Sachin.Nand

Did you try giving permission on schema to the user ?
Grant Select on Schema::[dbo] to [user]

PBUH

no doesnt work

_____________________

Yes O !

Sachin.Nand

2937 Posts

Posted - 2011-12-17 : 10:01:17

quote:
Originally posted by mary_itohan

quote:
Originally posted by Sachin.Nand

Did you try giving permission on schema to the user ?
Grant Select on Schema::[dbo] to [user]

PBUH

no doesnt work

_____________________

Yes O !

OK...So either you are doing something so stupid or you are not posting the whole scenario of your problem.

Is the user part of db_denyreader role ?

PBUH

mary_itohan
Posting Yak Master

191 Posts

Posted - 2011-12-17 : 10:46:30

quote:
Originally posted by Sachin.Nand

quote:
Originally posted by mary_itohan

quote:
Originally posted by Sachin.Nand

Did you try giving permission on schema to the user ?
Grant Select on Schema::[dbo] to [user]

PBUH

no doesnt work

_____________________

Yes O !

OK...So either you are doing something so stupid or you are not posting the whole scenario of your problem.

Is the user part of db_denyreader role ?

PBUH

You are right, funny i never added that on creation, must be the default in sql 2008 r2

_____________________

Yes O !

Sachin.Nand

2937 Posts

Posted - 2011-12-17 : 13:19:08

quote:
Originally posted by mary_itohan
You are right, funny i never added that on creation, must be the default in sql 2008 r2

_____________________

Yes O !

No its not.

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources