Solved

defining roles for sql tables? like read write

Posted on 2014-02-08
5
160 Views
Last Modified: 2014-04-14
What is the best way to do this?
0
Comment
Question by:goodk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 12

Assisted Solution

by:Tony303
Tony303 earned 500 total points
ID: 39844521
Here is a good article which covers users, roles and permissions....

http://www.techrepublic.com/article/understanding-roles-in-sql-server-security/
0
 

Author Comment

by:goodk
ID: 39846452
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
 
LVL 12

Assisted Solution

by:Tony303
Tony303 earned 500 total points
ID: 39846564
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
 
LVL 12

Accepted Solution

by:
Tony303 earned 500 total points
ID: 39846565
You also may want to change this questions Topics to a more Webby type topic area.
T
0
 

Author Closing Comment

by:goodk
ID: 39999316
thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compare a column in results by values left of decimal 2 34
point in time restore in SQL server 26 54
How to keep a record with the highest value 3 59
sql query 5 58
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question