Re: SQL 2005 user limit

From: Marcin S. (MarcinS_at_discussions.microsoft.com)
Date: 11/10/05 

Date: Thu, 10 Nov 2005 08:01:06 -0800

Hi,

I did find it the database must be owned by the user.

-----------------------
Marcin S.

"Andrew J. Kelly" wrote:

> 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: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)
  • Re: Delete Primary transaction Log
    ... your database and put it into suspect mode. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Fill Factor
    ... Well the only way it would go back to 90 is if someone or something is reindexing with a different fill factor. ... Andrew J. Kelly SQL MVP ... > database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: DataBase
    ... Andrew J. Kelly SQL MVP "Andrew J. Kelly" wrote in message ... Sorry I don't know anything about> dbase being supported with windows other than there are odbc and possibly> oledb drivers for it now, ... What I actually need to>> know>>>> is it posible to create this as a database and create tables in it, ...
    (microsoft.public.dotnet.languages.csharp)