Prev: DTS or Stored Procedure?
Next: Why this code does not work?
From: daicamad on 8 Feb 2010 15:41
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
From: Erland Sommarskog on 8 Feb 2010 17:21
daicamad (daicamad(a)gmail.com) writes:
> 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

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(a)sommarskog.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/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: DTS or Stored Procedure?
Next: Why this code does not work?