public role???
From: Rob (rhchin@hotmail.com)
Date: 02/17/03
- Next message: BP Margolin: "Re: public role???"
- Previous message: Ken Levy: "MSDE Install Error - "Strong SA Password is Required""
- Next in thread: BP Margolin: "Re: public role???"
- Reply: BP Margolin: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Rob" <rhchin@hotmail.com> Date: Mon, 17 Feb 2003 13:08:11 -0800
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.
- Next message: BP Margolin: "Re: public role???"
- Previous message: Ken Levy: "MSDE Install Error - "Strong SA Password is Required""
- Next in thread: BP Margolin: "Re: public role???"
- Reply: BP Margolin: "Re: public role???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]