In our SQL Server6.5, I drop a user from in one database using ‘sp_dropuse
r’
command, still with that specific login; I could able to access the database
.
It’s working fine in other database, but its not working only in one datab
ase.
For this login, there is no entries in Sysusers table of the respective
database.
Please help usWhat does 'SELECT USER' return? It may be that the login is mapped to a
different user in that database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dineshkumar" <Dineshkumar@.discussions.microsoft.com> wrote in message
news:0B35489E-175D-439D-8DF1-295B0B51AEE1@.microsoft.com...
> In our SQL Server6.5, I drop a user from in one database using
> 'sp_dropuser'
> command, still with that specific login; I could able to access the
> database.
> It's working fine in other database, but its not working only in one
> database.
> For this login, there is no entries in Sysusers table of the respective
> database.
> Please help us
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment