November 7, 2007 at 1:24 am
What is the different levels of security available in sqlserver2000 and sqlserver2005 ?
karthik
November 7, 2007 at 2:16 am
Could you explain a bit more what you mean by security level?
IF you're looking at db_roles, they are the same.
On server level some new permissions are introduced, mainly to access objects new to SQL 2005.
See http://www.microsoft.com/sql/technologies/security/whitepapers.mspx
for more information.
[font="Verdana"]Markus Bohse[/font]
November 7, 2007 at 7:16 am
karthikeyan (11/7/2007)
What is the different levels of security available in sqlserver2000 and sqlserver2005 ?
As the previous poster asked, "What do you mean by levels?"
SQL Server 2005 has more granular security, has built-in data encryption capabilities, encrypts the SQL Server login process, etc. What more are you looking for?
K. Brian Kelley
@kbriankelley
November 9, 2007 at 2:32 am
I am asking about DBO level securities.
karthik
November 10, 2007 at 10:07 am
A user who maps in as dbo isn't restricted in any way within that database. Permissions don't apply.
A user who is a member of the db_owner fixed database role can do anything within a database, but permissions still apply. This is much like file level permissions apply to a member of the local administrators group, but a member of that group can override any permissions, albeit by changing them.
This behavior isn't changed between the two versions (or even from version 7.0).
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply