[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

defining roles for sql tables? like read write

What is the best way to do this?
0
goodk
Asked:
goodk
  • 3
  • 2
3 Solutions
 
Tony303Commented:
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
 
Tony303Commented:
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
 
Tony303Commented:
You also may want to change this questions Topics to a more Webby type topic area.
T
0
 
goodkAuthor Commented:
thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now