Re: sql express 2005 security

Ming (stm@xxxxxxxxxxxxxxxxx) writes:
I can't get your meaning...?!
Since my application will run on a standalone machine, I can't force
user to login using specific username.
If they can login, they can view the data, right?

Also, how could I distribute the application to client with a predefine
Windows a/c?
Cna you tell me more about them?

With Windows authentication, you don't include UserID and Password in
the connection strint, instead you have:

Integrated Security=SSPI;

All that is needed to make sure that the user has access to the server
and database.

And, yes, this means that the user will be able to connect to the database
by other means to view the data. But that is nothing you can prevent anyway.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with my SQL 2000 Maintenance plans.
    ... I wouldn't use maint plan for this. ... using the most recent update of Books Online). ... If you do have a problem in the database, you want to be alerted so you can do ... >> option will most probably be removed in next version of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Setting Up SQL Security
    ... want that user to have complete access to a database. ... But if it's impedient that no information whatsoever is ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)