Accounts

From WolfTech
Revision as of 15:35, 21 June 2006 by Djgreen (talk | contribs)
Jump to: navigation, search
WolfTech Accounts and Policies

Split into subpages, and combine in the Policy page links.

MySQL Account

Creation

Databases are created for projects on an as-needed basis. To request, send email to ece-webmaster@ncsu.edu. You will need to include:

  1. Name of the project.
  2. Names and Unity IDs of project participants.
  3. Names and Unity IDs of those who will have access to the database (if different from 3.)
  4. How project relates to ECE.

Format

All databases are assigned three username/password combinations with the following attributes:

<database name>-rd : SELECT
    Use in code when page will be used only to retrieve information from database.
<database name>-wrt : SELECT, INSERT, UPDATE, DELETE
    Use in code when page will be used to make changes to database.
<database name>-adm : SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
    Use only for logging into PHPMyAdmin to set-up database structure. NEVER USE IN CODE.

Deactivation

Administrative (-adm) accounts are deactivated upon completion of the project. Read (-rd) and write (-wrt) accounts may remain active as long as the completed project requires.