Changing security authentication type.

Hi,
in an existing instance of SQL, will changing the security authentication
from SQL & Windows logins, to only windows logins cause any issues?

Also, if a database has been created with hardly any security already, are
there any issues with introducing security further down the line. For
example, a SQL server has been deployed already by my predecessor, with
authentication in SA & windows mode, and allowing pretty much anyone access
to SQL. If i was to create a DBA_Admin group and assign admin writes only to
that group, will it cause any problems in a already functioning database?

TIA


.

Relevant Pages

  • Re: Which database should I use?
    ... > and alter the database. ... That is exactly what is possible with SQL server and for a fact with all ... other RDBMS systems but not with Access in combination with a Workgroup ... >only weak point is on security. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: External .mdb inside Forms
    ... > You can set a form's recordsource or a combo box's rowsource to a SQL ... > Note that this method can be used if the external database is secured ... > security, but this is fundamentally insecure and I don't think there's ...
    (microsoft.public.access.forms)
  • Re: Multiple Database Security - How to handle
    ... There is no 'execute as' in SQL Server but you can simplify security ... Assuming the DM database contains tables that are accessed only by ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Access Security Best Practices when linking to a SQL back end
    ... Before Access can verify the username and password in the SQL ... Access authenticates the user before the database actually opens. ... own security algorithm is not going to be an easy task. ... > was originally written to use access's own .mdw file for security. ...
    (microsoft.public.access.security)
  • Re: Putting/retriving files into a database
    ... Also, *never* put user-supplied input in an SQL ... attention to what it says about SQL Injection in the "Database ... Security" section. ... Study the "Handling File Uploads" chapter in the PHP ...
    (comp.lang.php)