Access 2000-Modify User Logon Name

  • Thread starter Thread starter Bic Pham
  • Start date Start date
B

Bic Pham

We are using Access 2000 SP3, have a centralized security
workgroup (xxx.mdw) where all users are connected to it
(by running wrkgadm.exe). This workgroup contains all
users logon names. The current user name format is 3
characters long (e.g. D99). We would like to change to a
new format (e.g. johndoe). Is there a way I can change the
current user name to a new logon name without having to
create a new one (and having to reassign all the security
groups to the new one?) Each user name may have several
security groups assigned to it because the user has access
to several databases. Your prompt reply is appreciated.
 
--------------------
| Content-Class: urn:content-classes:message
| From: "Bic Pham" <[email protected]>
| Sender: "Bic Pham" <[email protected]>
| Subject: Access 2000-Modify User Logon Name
| Date: Tue, 13 Jan 2004 07:06:02 -0800
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPZ5sKxypD4AWYVTWOR1/tJsEAwnw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.security:7446
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.security
|
| We are using Access 2000 SP3, have a centralized security
| workgroup (xxx.mdw) where all users are connected to it
| (by running wrkgadm.exe). This workgroup contains all
| users logon names. The current user name format is 3
| characters long (e.g. D99). We would like to change to a
| new format (e.g. johndoe). Is there a way I can change the
| current user name to a new logon name without having to
| create a new one (and having to reassign all the security
| groups to the new one?) Each user name may have several
| security groups assigned to it because the user has access
| to several databases. Your prompt reply is appreciated.
|

Hi,

You will have to create a new user name. But as a workaround you can use
the code in the following article:
ACC2000: How to Add a User to a Group with CreateUser Method
http://support.microsoft.com/default.aspx?scid=kb;en-us;210418

You can modify the code to where you would loop thru all the Groups the
previous User belonged to and add the new account to the same Groups.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Hi Bic

AFAIK there is no way to *rename* an existing user. However, you could
write some code to:
1. Create the user "JohnDoe"
2. For each group of which D99 is a member, assign JohnDoe to that group
3. Delete the user D99

You will find example code to perform all of these operations in the Access
Security FAQ at http://support.microsoft.com/?id=207793

If you write a function to do all this, given two arguments (OldUser and
NewUser), you can call it once for each pair and the job will be done.
 
This is why many recommend that you never give permissions to anyone at the
user level, but rather only to groups and let the users inherit them. It
solves a lot of maintenance issues like this.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Graham Mandeno said:
Hi Bic

AFAIK there is no way to *rename* an existing user. However, you could
write some code to:
1. Create the user "JohnDoe"
2. For each group of which D99 is a member, assign JohnDoe to that group
3. Delete the user D99

You will find example code to perform all of these operations in the Access
Security FAQ at http://support.microsoft.com/?id=207793

If you write a function to do all this, given two arguments (OldUser and
NewUser), you can call it once for each pair and the job will be done.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Bic Pham said:
We are using Access 2000 SP3, have a centralized security
workgroup (xxx.mdw) where all users are connected to it
(by running wrkgadm.exe). This workgroup contains all
users logon names. The current user name format is 3
characters long (e.g. D99). We would like to change to a
new format (e.g. johndoe). Is there a way I can change the
current user name to a new logon name without having to
create a new one (and having to reassign all the security
groups to the new one?) Each user name may have several
security groups assigned to it because the user has access
to several databases. Your prompt reply is appreciated.
Click to expand...
Click to expand...
 
Hi Rick
This is why many recommend that you never give permissions to anyone at the
user level, but rather only to groups and let the users inherit them. It
solves a lot of maintenance issues like this.
Click to expand...

The way I read it, Bic is already doing this correctly. He has a number of
users each of whom is a member of a number of groups. He wants, not to
assign *permissions* to the users he's creating, but to assign them to
*groups* (from which they will inherit the required permissions).

Cheers,
Graham
 
Back
Top