Hi!...
For an existing user, iam providing user acces to existing db as dbOwner, Databse is SQL2005 Standard edition
The way i've done is by selecting the user from Security-Login-UserName - UserMappings here ive selected the database and dbowner.
When i login to with this newly set username and password it works fine for selecting, new table, sp creation, deletion etc... but if i try to modify the table structure iam prompted with an error
"SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. (.net SqlClient Data provider)"
Please suggest a solution and where i've gone wrong or try...