469,097 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

Security issues in SQL Server 2005

I cannot block user access to tables. I have restriced accounts at the
server, database, group, schema, and table lavel and can still open
tables right up.

In other words, I have absolutely no security. Any ideas?

Dec 14 '06 #1
1 1171
Bergs (sg****@yahoo.com) writes:
I cannot block user access to tables. I have restriced accounts at the
server, database, group, schema, and table lavel and can still open
tables right up.

In other words, I have absolutely no security. Any ideas?
Do I understand this right that you don't want unprivleges users to be
able to perform SELECT, INSERT, DELETE and UPDATE operations on tables?

Since this is the default behaviour, you must have added something which
that gives users access. Or you are accessing the databasee with users
that have db_owner privilege.

To get some more inforamtion, I would like to know:

1) Which version of SQL Server you are using.

2) The output from sp_helprotect on a table you want to prevent access to.

3) The output from sp_helpuser on a user you want to deprive access.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Jason | last post: by
5 posts views Thread by Norsoft | last post: by
8 posts views Thread by =?Utf-8?B?aWxy?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.