Security issues in SQL Server 2005

[Bergs]

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?

[Erland Sommarskog]

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