Announcement Announcement Module
Collapse

myhosting.com Forum Guidelines

Welcome to the myhosting.com Forums! The purpose of this forum is to allow you to discuss topics relating to hosting and topics of interest with other myhosting.com Customers. The primary focus should relate to issues not generally included in our Wiki or Control Panel, or information not provided by our Customer Support Team. Some examples include programming and coding support, web site design ideas and SEO practices.

The forum is not meant as a replacement to our Wiki or Customer Support. We highly recommend searching our Wiki before posting on the forum. Also, if you have a question for our Customer Support team, please contact them as you would normally.

We ask that if you have any complaints or questions relating specifically to your account, that you address them to our Customer Support department. Do not post personal account information such as passwords or other sensitive and private information the forum, as this type of information is best kept secret. Also, please be respectful of other users and refrain from defamatory comments or use of coarse language.

We will visit the forum from time to time, and contribute to various topics. We reserve the right to delete any posts which are deemed offensive or against the spirit of the forum. Any spamming or illegal activity will not be tolerated. We also reserve the right to block any user who violates these guidelines.

To get started, we welcome you to sign up at our User Management site. Any account created there will have access to these forums, our Wiki, our Ideas site and commenting permission on our Status Blog.
See more
See less
Multiple SQL users Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple SQL users

    Is it possible to create multiple users in SQL server with different levels of access?

  • #2
    Re: Multiple SQL users

    Yeap, here you go...

    Role types
    Server roles are maintained by the database administrator (DBA) and apply to the entire server, not an individual database file. The public role sets the basic default permissions for all users. Every user thatís added to SQL Server is automatically assigned to the public roleóyou donít need to do anything. Database roles are applied to an individual database.

    Predefined database roles
    You may need to create your own, but you have access to several predefined database roles:

    db_owner: Members have full access.
    db_accessadmin: Members can manage Windows groups and SQL Server logins.
    db_datareader: Members can read all data.
    db_datawriter: Members can add, delete, or modify data in the tables.
    db_ddladmin: Members can run dynamic-link library (DLL) statements.
    db_securityadmin: Members can modify role membership and manage permissions.
    db_bckupoperator: Members can back up the database.
    db_denydatareader: Members canít view data within the database.
    db_denydatawriter: Members canít change or delete data in tables or views.

    Fixed roles
    The fixed server roles are applied serverwide, and there are several predefined server roles:

    SysAdmin: Any member can perform any action on the server.
    ServerAdmin: Any member can set configuration options on the server.
    SetupAdmin: Any member can manage linked servers and SQL Server startup options and tasks.
    Security Admin: Any member can manage server security.
    ProcessAdmin: Any member can kill processes running on SQL Server.
    DbCreator: Any member can create, alter, drop, and restore databases.
    DiskAdmin: Any member can manage SQL Server disk files.
    BulkAdmin: Any member can run the bulk insert command.

    Comment


    • #3
      Re: Multiple SQL users

      Originally posted by broncosfan
      Is it possible to create multiple users in SQL server with different levels of access?
      Please note that we do not currently support creation of additional users with MySQL or MS SQL databases. But this would be a great idea for http://ideas.myhosting.com if you would like to add it.

      Comment

      Working...
      X