Re: user account creation

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/15/05

  • Next message: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data" 
    Date: Wed, 14 Sep 2005 18:01:36 -0600

    In SQL Server 2000, if users are accessing SQL Server with
    Enterprise Manager, they can view the logins (but can modify
    without the appropriate permissions). They can also view all
    databases but can only access those they have permissions to
    access. That is the way it works in SQL Server 2000.

    -Sue

    On Wed, 14 Sep 2005 15:18:25 -0400, <rvegas@rogers.com>
    wrote:

    >I think i figured out what the problem is, but still dont know how to
    >prevent it.
    >All the databases have dbo=db_owner that has full permissions on the
    >database. So they can give access to their database to anyother user. Is
    >there a way to prevent users from seeing other users?
    >Thanx
    ><rvegas@rogers.com> wrote in message
    >news:%23a3epPUuFHA.3528@TK2MSFTNGP15.phx.gbl...
    >> Hi,
    >> I have an sql 2000 server with 150 databases setup. Users use enterprise
    >> manager to connect to the server. Heres where the problem arises, once
    >> they connect they can see all the databases.
    >> Also if i logon as a regular db owner. I can select create new user,
    >> select an existing user and make him an owner of my database.
    >> This doesn't seem right, can anyone help me fix this. Or point me in the
    >> right direction.
    >> Thank you
    >>
    >>
    >

  • Next message: Sophie Guo [MSFT]: "RE: 0x80004005 - you need permission to view its data"

    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)
    • Re: Execute Persmission denied on object sp_OACreate
      ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
      (microsoft.public.sqlserver.security)
    • Re: Newbie: I dont understand user permissions for table access
      ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
      (microsoft.public.sqlserver.server)
    • Re: Viewing default db role permissions
      ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
      (microsoft.public.sqlserver.security)
    • Re: Execute Persmission denied on object sp_OACreate
      ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
      (microsoft.public.sqlserver.security)