SQL Express Security Questions



Are the User ID, ex. sa, for Express part of the installation or are
they database dependent, eg. changeable per each MDB file? Eg. if I
change the password for sa, then this effects all connections to all
databases.

Also, are logon/users kept in the database file or separate? If I
create a database, can I create a logon and user login that will apply
only to that database file? And then can I specify this on the
connection string?

What I want is to allow a app with the correct ID/PW into a database,
but lock a user from opening and changing the database while NOT
causing issues with the SQL EXPRESS installation. Eg. Do not wish to
create problems!
.



Relevant Pages

  • Re: Release of GNADE 1.5.2
    ... Michael> Dear all the GNU Ada Database Development Environment Version ... This release of the GNADE project is intended for building with GNAT ... The GNADE project installation procedure provides for theses product ... 566413 1.3.5a static libraries not build for adbc Makefile modified ...
    (comp.lang.ada)
  • Re: WSS 3.0 upgrade problem
    ... "Costas" wrote: ... possible that while the installation tries to configure the database it ... finds the previous installation and it creates the error. ... The Spanish error text translates to "error ...
    (microsoft.public.windows.server.sbs)
  • Re: MAJOR SQL and SharePoint Upgrade - Help with Installation Overview
    ... The version of SQL Server 2005 Express used with the Basic installation of WSS 3.0 ("Windows Internal Database") does not have any size limits. ...
    (microsoft.public.sharepoint.windowsservices)
  • SNAP Innovations PrimeBase Database 4.2 poor default file permissions.
    ... "The PrimeBase Database Server is a relational Database Management System ... Poor use of temporary files during installation. ... The Mitre Corp.'s Common Vulnerabilities and Exposures Project ...
    (Bugtraq)
  • Re: SQL Server Express as an embedded database
    ... > The Express install can be embedded in your product's installation ... > software upgrade. ... > that includes the required ALTER statements to upgrade the database and ... >> capability of installing SQL Server databases, ...
    (microsoft.public.sqlserver.msde)