Printable View
You need to check the permissions against the defined logins in the 'Security' tab in SQL Server Enterprise Manager - you can disallow access to specific databases from there. The public role is defined for each database and you just need to make sure that that user is not defined.
the other thing to check is that this user is not being authenticated by NT via ODBC or whatever.
Cheers,
P.
Paul,
As u said, I checked for the permissions for the 'wodlee' client user. The 'Database Access' is set only for his particular database.
Next, I also checked for the user in the master database. His user is not there in the master database. And the user is authenticating only thru SQL server authentication.
I had the same problem with some user-defined databases. The client user was able to access some user-defined databases for which he was not an authorised user. I solved that by knocking off the 'guest' user in the user-defined database. SQL server is not allowing me to knock off the 'guest' user in Master and tempdb, which are the only two databases which is able to be accessed by the unauthorized user.
Any idea?
Cheers
Within the guest user account in each database revoke permissions on all objects. That way they can't see or do anything. This is in Enterprise manager under users.
Double click on guest and you will see the list of permissions. Revoke them all.
Ensure that the public role doesn't have accesses that you don't want (guest will inherit them).
Cheers,
P.
Hi Paul,
Thanx for that. I did as u said. I restricted access for the list of objects. Its working fine. Thanx alot.
I've got another problem now. When the user tries to access the table for which he is authorised, it says - "Login failed for the User 'wodlee'" and asks for re-entering the username and password. When given correctly, its shows all the content of the table. Anyidea, what would be the problem???
Another question is, 'is there any way to hide a database. Suppose, I want my client to see only his database in the Enterprise Manager. Is there any way?
Thanx again in advance
Parasuraman