School-Admission-Management-System/authorization.php at master · rpldesh/School-Admission-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
/**
 * Created by PhpStorm.
 * User: DiniX
 * Date: 07-Nov-17
 * Time: 7:43 PM
 */
include "libs/Database.php";
include "config.php";
$db=new Database(DB_TYPE,DB_HOST,DB_NAME,'root',DB_PASS);

//$db->query("DELETE FROM USER");
$db->query("CREATE USER 'principal'@'localhost'");
$db->query("CREATE USER 'interviewer'@'localhost' ");
$db->query("CREATE USER 'inserter'@'localhost' ");
$db->query("CREATE USER 'admin'@'localhost' ");
$db->query("CREATE USER 'clerk'@'localhost' ");

$db->query("GRANT ALL PRIVILEGES ON *.* TO 'principal'@'localhost' ");
$db->query("GRANT ALL PRIVILEGES ON *.* TO 'interviewer'@'localhost' ");
$db->query("GRANT ALL PRIVILEGES ON *.* TO 'inserter'@'localhost' ");
$db->query("GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' ");
$db->query("GRANT ALL PRIVILEGES ON *.* TO 'clerk'@'localhost' ");

$db->query("REVOKE ALL PRIVILEGES ON interview FROM 'inserter'@'localhost'");
$db->query("REVOKE ALL PRIVILEGES ON interview_result FROM 'inserter'@'localhost'");
$db->query("REVOKE INSERT,UPDATE,DELETE ON users FROM 'inserter'@'localhost'");
$db->query("REVOKE INSERT,UPDATE,DELETE ON school_staff FROM 'inserter'@'localhost'");
$db->query("REVOKE INSERT,UPDATE,DELETE ON users FROM 'interviewer'@'localhost'");
$db->query("REVOKE INSERT,UPDATE,DELETE ON school_staff FROM 'interviewer'@'localhost'");
$db->query("REVOKE ALL PRIVILEGES ON interview_result FROM 'inserter'@'localhost'");

$db->query("REVOKE ALL PRIVILEGES ON interview FROM 'clerk'@'localhost'");
$db->query("REVOKE ALL PRIVILEGES ON interview_result FROM 'clerk'@'localhost'");
$db->query("REVOKE INSERT,DELETE ON users FROM 'clerk'@'localhost'");


?>