RE: BDO view objects in Enterprise Manager

From: mike.mullane@hpinc.com
Date: 10/21/02 

From: <mike.mullane@hpinc.com>
Date: Mon, 21 Oct 2002 14:50:18 -0700

Thank you Bill, very useful information. Now things are
behaving the way I expect and want.

Mike

>-----Original Message-----
>Hi Mike,
>
>>From http://msdn.microsoft.com/library/en-
us/architec/8_ar_da_8yur.asp:
>{
>If a database has no guest user account, a login cannot
access the database
>unless it has been associated with a valid user account.
>}
>IOW, once you explicitly add the user to the database,
the database's
>objects will be visible to that user.
>
>However, this dosen't fit with your observation that
these users are
>database owners <g>, so, how are you determining they are
database owner?
>And what steps were followed to remove guest? If you
directly deleted guest
>from sysusers then please see
>http://support.microsoft.com/support/kb/articles/q315/5/23
.asp.
>
>Perhaps select from a database's sysusers with a
compare/join
>master..sysxlogins by sid and/or name, or (for SQL Server
logins) a report
>mode run of sp_change_users_login will reveal some
additional information
>(such as orphaned users). If the user is found, then
sp_helpuser will
>return that user's database roles (including the db_owner
fixed database
>role).
>
>BTW, if the model database has the guest user then all
new databases will
>the guest user as well since the databases are all based
upon/templated
>from the model database.
>
>
>Thanks,
>
>Bill Hollinshead
>Microsoft, SQL Server
>
>This posting is provided "AS IS" with no warranties, and
confers no
>rights. Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>

Relevant Pages

  • Re: How to remove `guest as Default Login ID in MSSQL2000?
    ... "guest" is not a login but is a database user. ... The guest user account allows a login without a user account to access a ... A login assumes the identity of the guest user when both of the ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint SQL Databases guest user account ?
    ... Note that dropping the guest user does not physically drop the user from the ... database but only disables it. ... database access can access a user database when guest is disabled. ... adding the guest user enables it. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove "guest" account in SQL Server 2000
    ... Note that dropping the guest user does not physically drop the user from the database but only disables it. ... adding the guest user enables it. ...
    (microsoft.public.sqlserver.security)
  • Re: db_datareader role**
    ... To see if the guest user is enabled in a particular database: ... >> A login can access a database only if the login is a user in the ... >> The public role has SELECT permissions on system tables and views. ...
    (microsoft.public.sqlserver.security)
  • Re: Minimum Permission Create table in TempDB
    ... It is just a way to be a database user without specifically making someone a user. ... As a guest user you acquire any rights either granted to the public role or directly to the guest user. ... Another thing about creating users in tempdb is that tempdb itself is recreated each time the SQL Server restarts. ...
    (microsoft.public.sqlserver.security)