5.9.2 Security & access

6 entries match these filters

• 0200 PostgreSQL roles, privileges and default privileges Create login and group roles, grant access to databases, schemas and tables, and use ALTER DEFAULT PRIVILEGES so tables created later get… Intermediate · How-to · Linux Article Roles & administration · Security & access 15 Oct 2026
• 0214 MySQL users and privileges: CREATE USER, GRANT and authentication plugins A MySQL account is a user name plus the host it connects from. You create it with CREATE USER, give it rights… Beginner · How-to · Linux Article Administration · Security & access 15 Oct 2026
• 0223 Oracle users, roles and tablespaces: setup script and usage report (SQL) A SQL*Plus/SQLcl script that creates a tablespace, a role and an application user inside a PDB, then reports tablespace usage from the… Intermediate · How-to · Any system Script Administration · Security & access 15 Oct 2026
• 0233 Turn on MongoDB authentication and create least-privilege users A fresh MongoDB install accepts connections without a password. Create a user administrator, enable authorization, then give each application and backup job… Intermediate · How-to · Linux Article Administration · Security & access 15 Oct 2026
• 0242 Database security checklist: access, encryption, exposure and patching A practical checklist for hardening any database server, with MongoDB and Redis examples: no public exposure, authentication, least privilege, TLS, protected backups,… Advanced · How-to · Linux Article Database operations · Security & access 15 Oct 2026
• 0243 Database backup strategy: the 3-2-1 rule and testing restores Keep three copies of your data on two kinds of storage with one copy offsite, choose dump or snapshot methods per database,… Intermediate · How-to · Linux Article Database operations · Security & access 15 Oct 2026