Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 Security - Enabling a non Admin user to create logins

Status
Not open for further replies.
Jan 2, 2000
1
GB
Is there any way of enabling a non-admin user to create logins without being a member of Admins?<br>
<br>
I can think of 2 options which may or may not work<br>
<br>
1 Temporarily elevate user to Admin groups in code behind protected form<br>
<br>
2 Use the SQL CREATE USER statement with OwnerAccess options in a query (run by a form accessible only to the Account Manager's group) owned by a member of Admins.<br>
<br>
Anyone tried these or other approaches or have any other ideas/info?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top