Login and User in SQL Server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-11 : 09:18:39

Gopinath writes "Hi,

There is a database called 'xmanager', this database was restored from its backup file.
on restoring, this had an user called 'xtool' in it.

now, my problem is,
when i try to create a login called 'xtool', it is creating. but,for that login,i am not able to make the default database as 'xmanager'. it says 'xtool' user already exists.

when i try to delete the 'xtool' user in the database, it says 'xtool' user cannot be dropped because the user owns the object.

i want to use the same user'xtool' present in that database.
is this possible?

kindly help me out in resolving this issue,
Thanks in Advance.

Regards,
Gopi."

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-08-11 : 10:44:27

Ok try like this:
Go to SQL server Instance
Create the user(if not available) from Security --> Logins
Do not "tick" the Server or DB roles

Now go to Database
Go to Users
Check whether the user is there,
if so give the appropriate permissions.
Else Add a new user (right click, select first menu item)
Select the Login name from the list and proceed

Srinika

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources