Internal, open access

Setting Permissions on your SQL Server database

Introduction

Default permissions

When the database is initially created, the user requesting the database is assigned the role of Database Owner (dbo).  There can only be one dbo per database.  The dbo has full control over the database, including the ability to delete their own database.  Please do NOT do this as it may affect your access to the server itself and you will no longer be able to login.  If you do wish to have a database deleted, please email a request to ITS Help.  It can then be processed correctly so that your access to other databases that you may have on the server is not affected.

At this stage, no other users have access to your database.

Permissions not available to the database owner

Whilst the dbo has full control over their own database, there are features that you will be able to see in Web Data Administrator over which you do not have control.

You will be able to see the databases master, msdb and tempdb, but you do not have any permissions on these tables and attempting to edit them will cause you errors.

Also note that your database has been created for you and it will be on the list. You do not have permissions to create additional databases - IT Services will do this for you via the Application for an MS SQL Server Database form. Attempting to create your own databases will cause an error.

In addition, whilst you will be able to view the Properties of your database, you will not be able to change the settings for Data Files and Transaction Logs.

Setting permissions on an Access database held in the data partition of the web server

In order for your web pages to work correctly you will need to set the permissions for your database in the data partition area. Do this as follows:

Ensure you have the data partition mounted so that you can access your database (the original share is set up by WST):

  1. Map network drive (right-click on the icon on the top left of the My Computer window)
  2. Select a drive letter
  3. \\vis2kws1\sharename
  4. Click on [Connect using a different username]
  5. Type in rdg-home\WIP_username and the password and then click [OK]

You will now see your data folder.

Things to do now

Page navigation

 

Search Form

A-Z lists