defining roles for sql tables? like read write

Posted on 2014-02-08
Last Modified: 2014-04-14
What is the best way to do this?
Question by:goodk
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
LVL 12

Assisted Solution

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

Author Comment

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.
LVL 12

Assisted Solution

Tony303 earned 500 total points
ID: 39846564

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

Here is TSQL to add a user to a role.

LVL 12

Accepted Solution

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

Author Closing Comment

ID: 39999316

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 ( 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