defining roles for sql tables? like read write

What is the best way to do this?
goodkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Tony303Connect With a Mentor Commented:
You also may want to change this questions Topics to a more Webby type topic area.
T
0
 
Tony303Connect With a Mentor Commented:
Here is a good article which covers users, roles and permissions....

http://www.techrepublic.com/article/understanding-roles-in-sql-server-security/
0
 
goodkAuthor Commented:
I read the article but I am confuse as how to use this security.

I am using shared sql db on a shared server on Godaddy,com

I have a website which will have new users obviously their role would be defined but I do not know what command I will run.  This example show use of the menus, whereas I can only run commands.
0
 
Tony303Connect With a Mentor Commented:
Hey,

Oh.... I am really not familiar with these cloud providers. You'd probably be better off on GoDaddy's site...

http://support.godaddy.com/help/article/34/setting-up-an-access-database-for-your-hosting-account?countrysite=nz

But,
Here is TSQL to add a user to a role.
http://technet.microsoft.com/en-us/library/ms187750.aspx

T
0
 
goodkAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.