User Tools

Site Tools


admin:processes:db_accounts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
admin:processes:db_accounts [2017/03/25 23:05] – [Oracle (Asuka)] localadminadmin:processes:db_accounts [2017/03/25 23:22] (current) – [PostgreSQL (Shinji)] localadmin
Line 18: Line 18:
  
 ===== MS SQL Student Server (msdb.cs.ndsu.nodak.edu) ===== ===== MS SQL Student Server (msdb.cs.ndsu.nodak.edu) =====
-------+{{:line.png?nolink|}} 
 This server exists solely for students to use in coursework.  (Back in the Helsene Dynasty, students were using Gendo for their coursework.  Gendo is also the database used by VMware, which made us scared enough to spawn up another box.).  Every database account on this machine is a local SQL account (thus not using Windows Authentication, which seemed easiest). This server exists solely for students to use in coursework.  (Back in the Helsene Dynasty, students were using Gendo for their coursework.  Gendo is also the database used by VMware, which made us scared enough to spawn up another box.).  Every database account on this machine is a local SQL account (thus not using Windows Authentication, which seemed easiest).
  
Line 26: Line 27:
  
 ===== MS SQL (Gendo) Production Server ===== ===== MS SQL (Gendo) Production Server =====
-----+{{:line.png?nolink|}} 
 ^ Server ^ Account purpose ^ Authentication source ^ ^ Server ^ Account purpose ^ Authentication source ^
 | gendo.cs.ndsu.nodak.edu | Student account :?:| Computer Science domain | | gendo.cs.ndsu.nodak.edu | Student account :?:| Computer Science domain |
Line 99: Line 101:
  
 ===== Oracle (Asuka) ===== ===== Oracle (Asuka) =====
----- +{{:line.png?nolink|}} 
-Oracle accounts are now done through CCAST.+ 
 +<color #ed1c24>Oracle accounts are now done through CCAST.</color>
  
 ^ Server ^ Account purpose ^ Authentication source ^ ^ Server ^ Account purpose ^ Authentication source ^
Line 179: Line 182:
    
 ===== MySQL (Rei) ===== ===== MySQL (Rei) =====
-----+{{:line.png?nolink|}} 
 ^ Server ^ Account purpose ^ Authentication source ^ ^ Server ^ Account purpose ^ Authentication source ^
 | rei.cs.ndsu.nodak.edu | student/application account | Local to mySQL server | | rei.cs.ndsu.nodak.edu | student/application account | Local to mySQL server |
Line 208: Line 212:
  
 ===== PostgreSQL (Shinji) ===== ===== PostgreSQL (Shinji) =====
-----+{{:line.png?nolink|}} 
 + 
 +<color #ed1c24>Postgres hasn't been offered by the department since at least 2014 if not earlier.</color> 
 ^ Server ^ Account purpose ^ Authentication source ^ ^ Server ^ Account purpose ^ Authentication source ^
 | shinji.cs.ndsu.nodak.edu | student account | Computer Science domain | | shinji.cs.ndsu.nodak.edu | student account | Computer Science domain |
admin/processes/db_accounts.1490501140.txt.gz · Last modified: by localadmin