Difference between revisions of "Accounts"

From WolfTech
Jump to: navigation, search
m
m
Line 2: Line 2:
 
Split into subpages, and combine in the Policy page links.
 
Split into subpages, and combine in the Policy page links.
 
==MySQL Account==
 
==MySQL Account==
===Creation===
 
Databases are created for projects on an as-needed basis.  To request, send email to [mailto:ece-webmaster@ncsu.edu ece-webmaster@ncsu.edu].  You will need to include:
 
<ol>
 
<li>Name of the project.</li>
 
<li>Names and Unity IDs of project participants.</li>
 
<li>Names and Unity IDs of those who will have access to the database (if different from 3.)</li>
 
<li>How project relates to ECE.</li>
 
</ol>
 
 
===Format===
 
All databases are assigned three username/password combinations with the following attributes:
 
 
<database name>-rd : SELECT<br />
 
&nbsp;&nbsp;&nbsp;&nbsp;Use in code when page will be used only to retrieve information from database.<br />
 
<database name>-wrt : SELECT, INSERT, UPDATE, DELETE<br />
 
&nbsp;&nbsp;&nbsp;&nbsp;Use in code when page will be used to make changes to database.<br />
 
<database name>-adm : SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP<br />
 
&nbsp;&nbsp;&nbsp;&nbsp;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.
 

Revision as of 15:36, 21 June 2006

WolfTech Accounts and Policies

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

MySQL Account