From b598a79d270b3a91b0e6d5f3b9dca4aecca2dd4c Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Sat, 2 Aug 2025 13:02:43 -0500 Subject: fix: convert README.org to README.md --- databases/sql/README.org | 36 ------------------------------------ 1 file changed, 36 deletions(-) delete mode 100644 databases/sql/README.org (limited to 'databases/sql/README.org') diff --git a/databases/sql/README.org b/databases/sql/README.org deleted file mode 100644 index 82b8911..0000000 --- a/databases/sql/README.org +++ /dev/null @@ -1,36 +0,0 @@ -* =admins.sql= - -#+begin_src sql -:r admins.sql -#+end_src - -#+begin_src text -| UserName | UserType | DatabaseUserName | Role | PermissionType | PermissionState | ObjectType | ObjectName | ColumnName | -|-------------+--------------+------------------+-----------------+----------------+-----------------+----------------------+--------------------+------------| -| SCOTT | SQL User | SCOTT | NULL | SELECT | GRANT | USER_TABLE | EMPLOYEES | NULL | -| SCOTT | SQL User | SCOTT | NULL | INSERT | GRANT | USER_TABLE | EMPLOYEES | NULL | -| HR | SQL User | HR | NULL | EXECUTE | GRANT | SQL_STORED_PROCEDURE | SP_GET_EMPLOYEE | NULL | -| APP_USER | Windows User | APP_USER | ApplicationRole | SELECT | GRANT | VIEW | vw_EmployeeDetails | NULL | -| APP_USER | Windows User | APP_USER | ApplicationRole | INSERT | GRANT | USER_TABLE | EMPLOYEES | NULL | -| {All Users} | {All Users} | {All Users} | public | SELECT | GRANT | USER_TABLE | EMPLOYEES | NULL | -| {All Users} | {All Users} | {All Users} | public | EXECUTE | GRANT | SQL_STORED_PROCEDURE | SP_GET_EMPLOYEE | NULL | -#+end_src - -* =passwords.py= - -#+begin_src shell -python passwords.py -#+end_src - -#+begin_src text -| Name | Type | Check Policy | Check Expiration | Reason | -|-------+-----------+--------------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------| -| user1 | SQL_LOGIN | PASS | FAIL | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is not enforced. | -| user2 | SQL_LOGIN | FAIL | FAIL | Password policy is not enforced. Password expiration is not enforced. | -| user3 | SQL_LOGIN | PASS | FAIL | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is not enforced. | -| user4 | SQL_LOGIN | PASS | FAIL | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is not enforced. | -| user5 | SQL_LOGIN | PASS | FAIL | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is not enforced. | -| user6 | SQL_LOGIN | PASS | PASS | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is enforced. Reviewer to check the expiration policy. | -| user7 | SQL_LOGIN | PASS | PASS | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is enforced. Reviewer to check the expiration policy. | -| user8 | SQL_LOGIN | PASS | PASS | Password policy is enforced. Reviewer to check the assigned policy. Password expiration is enforced. Reviewer to check the expiration policy. | -#+end_src -- cgit v1.2.3-70-g09d2