Re: public role???

From: BP Margolin (bpmargo@attglobal.net)
Date: 02/17/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Mon, 17 Feb 2003 16:16:38 -0500

Rob,

What exactly do you mean by "new users have access to all DBs"?

If you mean that new users can see the names of the other databases, but not
actually get into them, then that's the way SQL Server works.

If you mean that the new users can actually get into the other databases,
see if you have the "guest" account enabled in the other databases.

Documentation on the "guest" account is available in the SQL Server Books
Online.

-------------------------------------------
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.

"Rob" <rhchin@hotmail.com> wrote in message
news:025401c2d6c8$adaa5620$a101280a@phx.gbl...
> Hello:
>
> I created a couple of new SQL Server users giving them
> access to a particular DB only. When I attempt to login
> for these new users via SQL Query Analyzer, I've noticed
> that the new users have access to all DBs.
>
> Is this because of the default 'public' role's
> permissions. If yes, then would the public role's
> permission of all other DB that I wouldn't want the users
> to have access to, need to be restricted?
>
> Your comments are highly appreciated. Thanks.
>

Relevant Pages

  • Re: Configuring SQL 2000 for use with ESRI ArcSDE
    ... You can assign SQL Server users to database roles using sp_addrolemember: ... Permissions are entirely application specific. ... vendor for clarification of security requirements. ... I have Two databases 3 Roles ...
    (microsoft.public.sqlserver.server)
  • Re: Hiding database
    ... Jasper Smith (SQL Server MVP) ... >>>Can someone explan how to hide databases in enterprise manager. ... >> permissions are granted to these users. ... > have access rights to one of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: Security Script
    ... You when you restore a database, or attach it, SQL Server maintains the ... logins but removes all permissions to databases and their objects. ...
    (microsoft.public.sqlserver.security)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... but I tried this on a test server and the DBs ... Permissions should not have been lost if you simply detached and re-attached ... can I provide access to the databases for our developers through ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 7 to SQL 2000
    ... INF: Moving SQL Server databases to a new location with Detach/Attach ... Can one just use a BCP command to copy the dbs to an alternative> location or should I import the dbs. ...
    (microsoft.public.sqlserver.server)