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

From: BP Margolin (bpmargo@attglobal.net)
Date: 11/30/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sat, 30 Nov 2002 15:52:56 -0500

Shrenik,

Please see my reply in comp.databases.ms-sqlserver.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Shrenik Shah" <shrenik.s@directi.com> wrote in message
news:uUJFIUEmCHA.2644@tkmsftngp02...
> 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

  • db_owner Role (SQL Server 7.0 v/s SQL Server 2000)
    ... db_owner Role in SQL Server 7.0 and SQL Server 2000. ... allocations and other permissions. ... there are some Security Settings which can control this behavior. ...
    (microsoft.public.sqlserver.security)
  • 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)
  • 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: 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)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
    (microsoft.public.sqlserver.security)