Error in user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.
sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF
sql

Error in user permission

Hi,
I have a user 'AAA' who has NT Login to a database db1 on a test machine
running SQL Server 2000. I recently restored a database db2 from Production
machine to the test machine and I will call this db2_test. The production
machine didn't have the login 'AAA" set up.
Now after the restoration of db2_test I still see user 'AAA' in the list of
users and I am not able to drop it so that I can give permissions to 'AAA'
login for this restored database under the Security tab in Enterprise Manager.
I have tried running the Stored Procedure sp_change_users_login but it
didn't help.sharman,
I don't think I understand your description. Could you do the following
please and share the results:
use master
exec sp_helplogins 'AAA'
use db1
exec sp_helpuser 'AAA'
use db2_test
exec sp_helpuser 'AAA'
Do the SIDs all match? Do the sp_helpuser LoginNames match each other? Etc.
RLF