db_owner Role (SQL Server 7.0 v/s SQL Server 2000)

From: Shrenik Shah (shrenik.s@directi.com)
Date: 11/30/02 

From: "Shrenik Shah" <shrenik.s@directi.com>
Date: Sat, 30 Nov 2002 13:28:44 +0530

hi all,

Recently while setting up a DB Hosting Environment I saw a difference in
db_owner Role in SQL Server 7.0 and SQL Server 2000.

When I gave user a db_owner Role in SQL Server 7.0, he can view his database
properties like size allocations, permissions etc, but can't change any one
of them.

Where as same role applied to user in SQL Server 2000, being a db_owner he
is allowed to view his database properties and also he can change the file
allocations and other permissions.

What I am wondering is that, whether this is a new feature of SQL Server
2000 or

there are some Security Settings which can control this behavior.

I will really appriciate if any one helps me to clear my confusion and
understand the security much better.

Thanks in advance,

Shrenik.

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • That is permission problem
    ... SQL Server 2005 can't attach database on Windows Vista ... It seems it must be a permissions problem. ... What is the service account for SQL Server? ...
    (microsoft.public.sqlserver.tools)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)