Re: SQL 2005 user limit

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/10/05 

Date: Thu, 10 Nov 2005 09:30:55 -0500

What permissions do these users have? 

-- 
Andrew J. Kelly  SQL MVP
"Marcin S." <MarcinS@discussions.microsoft.com> wrote in message 
news:34EA31D1-6F12-4212-962E-0DEC79DD3428@microsoft.com...
> Hi,
>
> I just created two databases and two users but both users can see 
> eachothers
> databases. Is there eny example on technet/msdn?
>
> -- 
> -----------------------
> Marcin S.
>
>
> "Andrew J. Kelly" wrote:
>
>> I assume you meant it wasn't possible in SQL2000?   Yes it is possible in
>> 2005.  As a matter of fact by default a user will only see objects that 
>> they
>> have permissions to.  This even pertains to things like SQL Agent.  If 
>> the
>> user is not a member of one of the Agent roles they won't even see the 
>> Jobs
>> node.  You can even filter what objects you do see even if you have the
>> permissions to view them.
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Marcin S." <MarcinS@discussions.microsoft.com> wrote in message
>> news:93FD6DFA-DB57-4413-8C01-8EF038246FD1@microsoft.com...
>> > Hi,
>> >
>> > In SQL 2005 it was not possible to limit a user to list all databases 
>> > is
>> > it
>> > possible in SQL 2005? I cant fid any info about this issue.
>> >
>> > Main problem: a user should anly see hes/her own database
>> >
>> > (this is supported by MYSQL for long time now)
>> >
>> >
>> > -- 
>> > -----------------------
>> > Marcin S.
>>
>>
>>

Relevant Pages

  • Re: Error 22029 on Maintenance Plan
    ... > Thanks, Andrew, I'll give that a try. ... >> Andrew J. Kelly SQL MVP ... Maintenance plan 1 is for user databases ... >>> databases and does not do log backups. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 user limit
    ... Well those are pretty open permissions. ... Andrew J. Kelly SQL MVP ... "Marcin S." ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 user limit
    ... Marcin S. "Andrew J. Kelly" wrote:> What permissions do these users have? ... > Andrew J. Kelly SQL MVP ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Located databases no longer used.
    ... Everyone wants that feature though. ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ... >>> a specified period of time; we are looking to locate databases that are ...
    (microsoft.public.sqlserver.tools)
  • Re: Moving the Data directory in Desktop Edition
    ... Andrew J. Kelly SQL MVP ... "boe" wrote in message ... > Is it possible to change the location of the databases on the desktop ...
    (microsoft.public.sqlserver.server)