What rights do my users need?

[Invicta]

I'm new to SQL Server and I've just written my first application as a learning exercise.<br><br>I've tried giving my users datareader and datawriter rights to the database but this didn't work.&nbsp;&nbsp;Giving the users serveradmin rights fixes the problem so its not a client-server access issue.&nbsp;&nbsp;Can someone please tell me what rights I need to give my users to allow them to read and write data to existing tables?

 

[foxdev]

Hmm, in development I typically give Public, Datareader, and Datawriter rights, so it <i>should</i> work.<br><br>Is the database marked as &quot;DBO use only&quot;?&nbsp;&nbsp;<br>Is it marked &quot;read only&quot;?<br><br>You can determine these in the Enterprise Manager by right-clicking (or right-clucking, if you're a chicken) on the database and choosing properties. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[Invicta]

Thanks for responding Robert.<br><br>The database is not marked Dbo only, nor is the database read-only.&nbsp;&nbsp;In fact, I had to manually set the rights to SELECT, INSERT, UPDATE and DELETE against each table in the PUBLIC role for my users to have access.&nbsp;&nbsp;I thought that this is what the Datareader and Datawriter options were all about.&nbsp;&nbsp;I set up my users AFTER creating the tables so do the datareader and datawriter rights only affect tables added from that point on?<br><br>Ceating logins, dbaccess, roles and adding members to roles through T-SQL work fine although I explicitly granted the necessary rights to tables and SPs so I would expect no problems.<br>

 

[foxdev]

sp_addrolemember with DataReader and DataWriter seems to work just fine for me.&nbsp;&nbsp;In my development databases, I've never assigned explicit statement and object permissions, and all the developers can access and change without a hitch.&nbsp;&nbsp;I can't imagine what would be different about your system.&nbsp;&nbsp;I do know, though, that when using EM for assigning roles I've accidently checked the Deny* options. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>