Ben I haven't done this for a long time so before doing this I would suggest making a backup copy of the database. RENAME owner public to WhatEverNameYouWant SET user password for WhatEverNameYouWant TO somepassword You will have to grant access to tables, forms, reports,views for users using the GRANT command. Hope this helps Buddy
-----Original Message-----
From: Benjamin Strickland [mailto:[EMAIL PROTECTED]
Sent: Sun 8/15/2004 9:49 AM
To: RBG7-L Mailing List
Cc:
Subject: [RBG7-L] - Re: Database Owner, User ID and Password.
What is the correct procedure for changing the Owner in a database and then
creating a Password for the purpose of requiring this information before the
database will connect.
B. Strickland
--- RBG7-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
<<winmail.dat>>
