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)
 Read only user

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2006-04-17 : 10:08:46
guys,

I have created user developer and assigned it 2 roles (public, db_datareader), but still I am able to run DMl
updates on the databse ny logging with developer user.

Is there something that I am missing

any suggestions/inputs would help

Thanks

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-17 : 10:11:52
check the public role permissions

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -