Re: Granting consultant access to database

Roberto,

Something that you might check. If you ran sp_grantdbaccess to make your
consultant a user in the database, that does not prove that he has access to
the server. You may also need to:

EXEC sp_grantlogin 'Corporate\BobTheConsultant'

If that is OK, then you should also check that the default database of his
login is a database to which he has access. The 'not a user' may come from
the default database.

RLF
"Roberto R" <RobertoR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE654755-B958-48AB-9B5A-BCF215916729@xxxxxxxxxxxxxxxx
Hi,

I need to grant a consultant access to one database on an sql server.
I do not want to give him remote access to the server.

I have installed the client tools (Enterprise manager) on his laptop.
I put him in Users and made him db_admin.

However, when he connects to the server and clicks on the tables it says
he
is an invalid user error 916.

Any ideas how i can do this so its most secure. He needs to examine the
tables on the server. The SQL server is 2000.

Thanks


.

Relevant Pages