Logon Credential - SQL Server Forums

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)

Logon Credential

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-01 : 11:11:51

Nadeem writes "Hi

In SQL Server 2000, I've created a user in a database and with the same user I wish to register SQL Server thro' EM, I can able to register successfully but the database is not accessible. Can anyone help it out

Regards
Nadeem"

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-01 : 20:34:35

You can't register using user.
YOu may be using sql login to register and that log may not have the access to the database...or your default db may be incorrect...

What is the error your getting?

MohammedU

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-01 : 21:30:01

Did you grant access of the database to the user ?

asmanadeem
Starting Member

5 Posts

Posted - 2007-02-02 : 00:37:03

granted access to that particular user, it gets registered successfully but while you connect thro' that user, the database is not listed

asmanadeem
Starting Member

5 Posts

Posted - 2007-02-02 : 00:43:14

this is another clarification - i need to create some users in sql with update, insert and delete permissions to be given in a single database. what is the ideal way to do this? can anyone please let me know

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-02 : 01:59:50

First you need to create a login and then create a user under that login and grant the access..

Create a login ID and default database
This example creates a SQL Server login for the user Albert, with a password of food and a default database of corporate.

use master
go
EXEC sp_addlogin 'Albert', 'food', 'corporate'
use corporate
go
EXEC sp_adduser 'Albert', 'dbusername'
GRANT INSERT,UPDATE, DELETE ON OBJECTNAME TO DBUSERNAME...

MohammedU

asmanadeem
Starting Member

5 Posts

Posted - 2007-02-05 : 02:18:18

Hi

In your second statement, do we need to grant rights for each object, also what does it mean by dbusername.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources