Is it possible to copy a user from one WordPress site to another?
I copied the record from the user table and all the related records from the usermeta table (12 records by default) but I think something else is needed. I get this message upon login: You do not have sufficient permissions to access this page.
The reason I need this is I have 4 users I’d like to grant access to on a new site but use their credentials from the current site.
You need to make sure the new ID of the user in the user table matches the foreign key in the usermeta.
Also a word of caution regarding your comment on Active Directory integration. For public facing websites be extremely careful, you could inadvertantly expose you domain controller information to the web. You might want to consider additional security precautions around the login and admin pages, for example limiting access to certain IP addresses or dual authentication.