Hi all, while I work on SQL Server for some time but never being on
admin tasks.

I install SQL Server 2008 on Admin account of Windows 7, create a
database AB (used Window authenticate login or the login at
installation).
I create a Standard user account, and login to the database,
successfully. I attempt to access to database AB, and obviously
without success.

Now I have a question: Who I am just login to the server as a Standard
user?
When I login in as Standard user using Window authenticate, I see only
2 logins in that are BUILDIN\Users and sa

daicamad (daicamad (AT) gmail (DOT) com) writes:
BUILTIN\Users is a group that includes all users on the machine.

To see as whom you are logged in as, you can do

SELECT SYSTEM_USER

from a query window.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx