Computer Operations/sandbox

Revision as of 00:34, 14 November 2007 (view source) Watchdog (Talk | contribs) m ← Older edit		Latest revision as of 05:55, 31 December 2007 (view source) Watchdog (Talk | contribs) m (→‎Steve:)
(10 intermediate revisions by one user not shown)
Line 183:		Line 183:
−	==CD:==	+	==CD:===
		+	<br><br><br>
		+	O-Own Record<br> E-Everyones <br>This figures in after 'viewing record' of editing privilages in applicable areas.Let me know if more info is needed.<br><br><br>
	{| border=1		{| border=1
	|		|
Line 195:		Line 197:
	|-		|-
	|view record		|view record
−	|	+	|X(Own and everyones)
−	|	+	|X(own)
−	|	+	|X(Own and crew)
−	|	+	|X(Own and CO,XO's, ?Staff?)
−	|	+	|X(Own and ?Staff?)
−	|	+	|(X(Own and Student Courses)
	|-		|-
	|name		|name
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|rank		|rank
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+	|X(O, ?staff?)
−	|	+	|X(O)
	|-		|-
	|birthday		|birthday
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|lastupdate		|lastupdate
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|joindate		|joindate
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+	|X(O, ?staff?)
−	|	+	|X(O)
	|-		|-
	|username		|username
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|password		|password
−	|	+	|X(O+?E?)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
−	|	+	|X(O)
	|-		|-
	|db restricted		|db restricted
−	|	+	|X(O+E)
	|		|
	|		|
Line 267:		Line 269:
	|-		|-
	|active		|active
		+	|X(O+E)
	|		|
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+
	|		|
	|		|
	|-		|-
	|lds101		|lds101
−	|	+	|X(O+E)
−	|	+	|X(O-view only)
−	|	+	|X(O+Crew-view only)
−	|	+	|X(O+CO,XO?staf?-view only)
−	|	+	|X(O, ?staff?-view only)
−	|	+	|X(Own Students)
	|-		|-
	|lds201		|lds201
−	|	+	|X(O+E)
−	|	+	|X(O-view only)
−	|	+	|X(O+Crew-view only)
−	|	+	|X(O+CO,XO?staf?-view only)
−	|	+	|X(O, ?staff?-view only)
−	|	+	|X(Own Students)
	|-		|-
	|com101		|com101
−	|	+	|X(O+E)
−	|	+	|X(O-view only)
−	|	+	|X(O+Crew-view only)
−	|	+	|X(O+CO,XO?staf?-view only)
−	|	+	|X(O, ?staff?-view only)
−	|	+	|X(Own Students)
	|-		|-
	|contact data change		|contact data change
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
Line 308:		Line 310:
	|		|
	contact data add		contact data add
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
−	|	+
	|		|
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X(O+E)
−	|	+	|X(O)
−	|	+	|X(O+Crew)
−	|	+	|X(O+CO,XO?staf?)
	|		|
	|		|
	|-		|-
	|service data change		|service data change
		+	|X(O+E)
	|		|
	|		|
		+	|X-Some
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
	|-		|-
	|service data add		|service data add
Line 345:		Line 346:
	|		|
	|		|
−	|	+	|X(Own Students)
	|-		|-
	|service data delete		|service data delete
		+	|X(O+E)
	|		|
		+	|X(O+Crew)
		+	|X(Some)
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
−	|	+
	|-		|-
	|service data set admin flag		|service data set admin flag
		+	|X(O+E)
	|		|
	|		|
		+	|X(O+CO,XO, ?staff?)
	|		|
−	|	+	|X(Own Students)
−	|	+
−	|	+
	|}		|}
−
	==Rob:==		==Rob:==
Line 377:		Line 377:
	|-		|-
	|view record		|view record
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| 1
−	|	+	| 1?
−	|	+	| X
	|-		|-
	|name		|name
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|rank		|rank
−	|	+	| X
−	|	+	| .
−	|	+	| Non-Flag
−	|	+	| .
−	|	+	| Non-Flag
−	|	+	| .
	|-		|-
	|birthday		|birthday
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|lastupdate		|lastupdate
−	|	+	| 3
−	|	+	| .
−	|	+	| 3
−	|	+	| 3
−	|	+	| 3
−	|	+	|.
	|-		|-
	|joindate		|joindate
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|username		|username
−	|	+	| 2
−	|	+	| 2
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|password		|password
−	|	+	| 2
−	|	+	| 2
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|db restricted		|db restricted
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|active		|active
−	|	+	| X
−	|	+	| .
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|lds101		|lds101
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|lds201		|lds201
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|com101		|com101
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	|.
−	|	+	| 4
	|-		|-
	|contact data change		|contact data change
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|		|
	contact data add		contact data add
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|contact data delete		|contact data delete
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	| X
−	|	+	| X
−	|	+	| X
−	|	+	|.
−	|	+	|.
−	|	+	|.
	|-		|-
	|service data change		|service data change
−	|	+	| X
−	|	+	| .
−	|	+	| .
−	|	+	| 1
−	|	+	|.
−	|	+	| X
	|-		|-
	|service data add		|service data add
−	|	+	| X
−	|	+	| .
−	|	+	| X
−	|	+	| 1
−	|	+	| .
−	|	+	| 4?
	|-		|-
	|service data delete		|service data delete
−	|	+	| X
−	|	+	| .
−	|	+	| .
−	|	+	| .
−	|	+	|.
−	|	+	| .
	|-		|-
	|service data set admin flag		|service data set admin flag
−	|	+	| X
−	|	+	| .
−	|	+	| .
−	|	+	| X
−	|	+	|.
−	|	+	| X
	|}		|}
−		+	1. ZC's & **POSSIBLY** Branch Heads can only View **& Edit Certain Aspects** the records of Members in their Zone (and Branch).
−		+	2. These should never have to be changed. If we really need them changed then they can be done on the raw db level.
		+	3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit).
		+	4. These should normally update when a Dean enters data on these three courses on a module to be bulit.
	==Gary:==		==Gary:==
Line 744:		Line 746:
	|-		|-
	|view record		|view record
−	|	+	|X
−	|	+	|X
−	|	+	|X
−	|	+	|1
	|		|
	|		|
	|-		|-
	|name		|name
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 760:		Line 762:
	|-		|-
	|rank		|rank
		+	|X
	|		|
−	|	+	|X
−	|	+
	|		|
	|		|
Line 768:		Line 770:
	|-		|-
	|birthday		|birthday
−	|	+	|X
	|		|
	|		|
Line 775:		Line 777:
	|		|
	|-		|-
−	|lastupdate	+	|lastupdate 2 3
	|		|
	|		|
Line 783:		Line 785:
	|		|
	|-		|-
−	|joindate	+	|joindate 2
	|		|
	|		|
Line 791:		Line 793:
	|		|
	|-		|-
−	|username	+	|username 2
	|		|
	|		|
Line 800:		Line 802:
	|-		|-
	|password		|password
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 808:		Line 810:
	|-		|-
	|db restricted		|db restricted
−	|	+	|X
	|		|
	|		|
Line 816:		Line 818:
	|-		|-
	|active		|active
−	|	+	|X
	|		|
	|		|
Line 823:		Line 825:
	|		|
	|-		|-
−	|lds101	+	|lds101 4
−	|	+	|X
	|		|
	|		|
Line 831:		Line 833:
	|		|
	|-		|-
−	|lds201	+	|lds201 4
−	|	+	|X
	|		|
	|		|
Line 839:		Line 841:
	|		|
	|-		|-
−	|com101	+	|com101 4
−	|	+	|X
	|		|
	|		|
Line 848:		Line 850:
	|-		|-
	|contact data change		|contact data change
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 857:		Line 859:
	|		|
	contact data add		contact data add
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 865:		Line 867:
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 873:		Line 875:
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X
−	|	+	|X
	|		|
	|		|
Line 881:		Line 883:
	|-		|-
	|service data change		|service data change
−	|	+	|X
	|		|
	|		|
Line 888:		Line 890:
	|		|
	|-		|-
−	|service data add	+	|service data add 4
−	|	+	|X
−	|	+
−	|	+
	|		|
		+	|X
		+	|X
	|		|
	|		|
	|-		|-
	|service data delete		|service data delete
−	|	+	|X
	|		|
	|		|
Line 905:		Line 907:
	|-		|-
	|service data set admin flag		|service data set admin flag
−	|	+	|X
	|		|
	|		|
Line 913:		Line 915:
	|}		|}
		+	1. ZC's can only view the records of CO's and XO's of cells in their zones.<br>
		+	2. These should never have to be changed.  If we really need them changed then they can be done on the raw db level.<br>
		+	3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit).<br>
		+	4. These should normally update when a Dean enters data on these three courses on a module to be bulit.<br>
	==Steve:==		==Steve:==
		+
		+	*CC/membership head: X = Full access
		+	* for the following: V = Means view only & E = edit+view
		+	**O = Own Record
		+	**A = Everyones Record
		+	**B = Below self in applicable chain of command
		+	**S = Students Enrolled
		+	**? = Don't know/Don't understand field/function
		+	**2 = IF possible, otherwise none
		+	**3 = Non-Flag
		+
		+	IN GENERAL:
		+	* There needs to be some sort of flags editable by CC to denote membership in branches, zones, any other special units so that the permissions can work.
		+	* Perhaps a special text area ONLY viewable/editable by the CC is needed to record special circumstances such as serious problems, possible ethics violations, and such.
		+
		+
	{| border=1		{| border=1
	|		|
Line 925:		Line 947:
	|dean		|dean
	|-		|-
−	|view record	+	|view record (ONLY)
−	|	+	|X
−	|	+	|VO
−	|	+	|VB
−	|	+	|VB
−	|	+	|VB
−	|	+	|VS2
	|-		|-
	|name		|name
−	|	+	|X
	|		|
	|		|
Line 942:		Line 964:
	|-		|-
	|rank		|rank
		+	|X
	|		|
		+	|EB3
	|		|
−	|	+	|EB3
−	|	+
−	|	+
	|		|
	|-		|-
	|birthday		|birthday
−	|	+	|X
	|		|
	|		|
Line 958:		Line 980:
	|-		|-
	|lastupdate		|lastupdate
−	|	+	|X
	|		|
	|		|
Line 966:		Line 988:
	|-		|-
	|joindate		|joindate
−	|	+	|X
	|		|
	|		|
Line 974:		Line 996:
	|-		|-
	|username		|username
−	|	+	|X
	|		|
	|		|
Line 982:		Line 1,004:
	|-		|-
	|password		|password
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 990:		Line 1,012:
	|-		|-
	|db restricted		|db restricted
−	|	+	|X?
	|		|
	|		|
Line 998:		Line 1,020:
	|-		|-
	|active		|active
−	|	+	|X
	|		|
	|		|
Line 1,006:		Line 1,028:
	|-		|-
	|lds101		|lds101
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|lds201		|lds201
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|com101		|com101
		+	|X
	|		|
	|		|
	|		|
	|		|
−	|	+	|ES2
−	|	+
	|-		|-
	|contact data change		|contact data change
−	|	+	|X
−	|	+	|EO
−	|	+	|EB
−	|	+	|EB
	|		|
	|		|
Line 1,039:		Line 1,061:
	|		|
	contact data add		contact data add
−	|	+	|X
−	|	+	|EO
−	|	+	|EB
−	|	+	|EB
	|		|
	|		|
	|-		|-
	|contact data delete		|contact data delete
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 1,055:		Line 1,077:
	|-		|-
	|contact data show/noshow		|contact data show/noshow
−	|	+	|X
−	|	+	|EO
	|		|
	|		|
Line 1,063:		Line 1,085:
	|-		|-
	|service data change		|service data change
−	|	+	|X
	|		|
	|		|
Line 1,071:		Line 1,093:
	|-		|-
	|service data add		|service data add
		+	|X
	|		|
−	|	+	|EB
−	|	+	|EB
−	|	+	|EB
−	|	+	|ES2
−	|	+
	|-		|-
	|service data delete		|service data delete
−	|	+	|X
	|		|
	|		|
Line 1,087:		Line 1,109:
	|-		|-
	|service data set admin flag		|service data set admin flag
−	|	+	|X?
	|		|
	|		|
Line 1,094:		Line 1,116:
	|		|
	|}		|}
−
	==Will:==		==Will:==

---

Latest revision as of 05:55, 31 December 2007

Contents 1 Sam: 2 CD:= 3 Rob: 4 Gary: 5 Logan: 6 Steve: 7 Will:

[edit] Sam:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag

[edit] CD:=

O-Own Record
E-Everyones
This figures in after 'viewing record' of editing privilages in applicable areas.Let me know if more info is needed.

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X(Own and everyones)	X(own)	X(Own and crew)	X(Own and CO,XO's, ?Staff?)	X(Own and ?Staff?)	(X(Own and Student Courses)
name	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
rank	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)	X(O, ?staff?)	X(O)
birthday	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
lastupdate	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO)	X(O)	X(O)
joindate	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)	X(O, ?staff?)	X(O)
username	X(O+E)	X(O)	X(O)	X(O)	X(O)	X(O)
password	X(O+?E?)	X(O)	X(O)	X(O)	X(O)	X(O)
db restricted	X(O+E)
active	X(O+E)		X(O+Crew)	X(O+CO,XO?staf?)
lds101	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
lds201	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
com101	X(O+E)	X(O-view only)	X(O+Crew-view only)	X(O+CO,XO?staf?-view only)	X(O, ?staff?-view only)	X(Own Students)
contact data change	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data add	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data delete	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
contact data show/noshow	X(O+E)	X(O)	X(O+Crew)	X(O+CO,XO?staf?)
service data change	X(O+E)			X-Some		X(Own Students)
service data add						X(Own Students)
service data delete	X(O+E)		X(O+Crew)	X(Some)		X(Own Students)
service data set admin flag	X(O+E)			X(O+CO,XO, ?staff?)		X(Own Students)

[edit] Rob:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X	X	X	1	1?	X
name	X	X	X	.	.	.
rank	X	.	Non-Flag	.	Non-Flag	.
birthday	X	X	.	.	.	.
lastupdate	3	.	3	3	3	.
joindate	X	.	.	.	.	.
username	2	2	.	.	.	.
password	2	2	.	.	.	.
db restricted	X	.	.	.	.	.
active	X	.	X	X	.	.
lds101	X	.	.	.	.	4
lds201	X	.	.	.	.	4
com101	X	.	.	.	.	4
contact data change	X	X	X	X	.	.
contact data add	X	X	X	X	.	.
contact data delete	X	X	X	X	.	.
contact data show/noshow	X	X	X	.	.	.
service data change	X	.	.	1	.	X
service data add	X	.	X	1	.	4?
service data delete	X	.	.	.	.	.
service data set admin flag	X	.	.	X	.	X

1. ZC's & **POSSIBLY** Branch Heads can only View **& Edit Certain Aspects** the records of Members in their Zone (and Branch). 2. These should never have to be changed. If we really need them changed then they can be done on the raw db level. 3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit). 4. These should normally update when a Dean enters data on these three courses on a module to be bulit.

[edit] Gary:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag

[edit] Logan:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record	X	X	X	1
name	X	X
rank	X		X
birthday	X
lastupdate 2 3
joindate 2
username 2
password	X	X
db restricted	X
active	X
lds101 4	X
lds201 4	X
com101 4	X
contact data change	X	X
contact data add	X	X
contact data delete	X	X
contact data show/noshow	X	X
service data change	X
service data add 4	X		X	X
service data delete	X
service data set admin flag	X

1. ZC's can only view the records of CO's and XO's of cells in their zones.
2. These should never have to be changed. If we really need them changed then they can be done on the raw db level.
3. This will also update when ever any part of a person's record is updated or a CO/XO/ZC verifies they are still active (module to be bulit).
4. These should normally update when a Dean enters data on these three courses on a module to be bulit.

[edit] Steve:

• CC/membership head: X = Full access
• for the following: V = Means view only & E = edit+view
  • O = Own Record
  • A = Everyones Record
  • B = Below self in applicable chain of command
  • S = Students Enrolled
  • ? = Don't know/Don't understand field/function
  • 2 = IF possible, otherwise none
  • 3 = Non-Flag

IN GENERAL:

• There needs to be some sort of flags editable by CC to denote membership in branches, zones, any other special units so that the permissions can work.
• Perhaps a special text area ONLY viewable/editable by the CC is needed to record special circumstances such as serious problems, possible ethics violations, and such.

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record (ONLY)	X	VO	VB	VB	VB	VS2
name	X
rank	X		EB3		EB3
birthday	X
lastupdate	X
joindate	X
username	X
password	X	EO
db restricted	X?
active	X
lds101	X					ES2
lds201	X					ES2
com101	X					ES2
contact data change	X	EO	EB	EB
contact data add	X	EO	EB	EB
contact data delete	X	EO
contact data show/noshow	X	EO
service data change	X
service data add	X		EB	EB	EB	ES2
service data delete	X
service data set admin flag	X?

[edit] Will:

	ccmember/ membership head	member	co/xo	zc	branch head	dean
view record
name
rank
birthday
lastupdate
joindate
username
password
db restricted
active
lds101
lds201
com101
contact data change
contact data add
contact data delete
contact data show/noshow
service data change
service data add
service data delete
service data set admin flag