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)
 User

Author  Topic 

kaushik1975
Starting Member

3 Posts

Posted - 2001-08-10 : 05:24:53
Hello
I have a database where i have a table name UserName. The owner of this table is dbo.

I created a new user 'Kaushik'. I changed the owner of UserName to kaushik with sp_ChangeObjectOwner.

Then i logged in the the database with username as 'Kaushik' and tried on the table it gives error
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'UserName'

I have granted all rights to the user created
What may be the problem

   

- Advertisement -