Re: SQL User permissions

Did you add this login to sysadmin server role? If you did , remove it and
grant access to the db you would want





"ace95hockey" <ace95hockey@xxxxxxxxxxxxxx> wrote in message
news:F738DAC9-CD0B-468A-B845-DEE2183417E6@xxxxxxxxxxxxxxxx
I have SQL 2005 Standard installed in Mixed Mode

I am new to SQL and I want to setup a database off my SQL server that
another administrator will have access too. I created a new SQL account
and
gave it dbo permissions to only the database I created but when I log in
to
test this user has full access to see all databases. I would like to
change
this so this user can only see their database and nothing else. Please
let
me know if you can point me in the right direction.




.

Relevant Pages

  • Re: sql database security
    ... I wanted a database that is hidden such that ONLY my application can access ... I just read about embedded sql. ... "Standard Security" is SQL server's default login security mode. ... SA is part of the sysadmin server role and cannot be removed. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL open error
    ... > open a database in my C## program as before. ... SQL Server is configure to accept ... with admin priviledges, you don't have to grant access, as admins are ...
    (microsoft.public.data.oledb)
  • Re: multiple domain access
    ... we have a global group of the ... > sets up security and database access for the first SQL ... Find the database you wish to grant access to, check the box, and then ...
    (microsoft.public.sqlserver.security)
  • Re: IIS6 to access SQL db
    ... You need to grant access to the user in the database. ... Kristofer Gafvert - IIS MVP ... > I'm trying to setup iis to access a sql db which is in a separate machine in the same domain. ...
    (microsoft.public.inetserver.iis)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)