Please enable JavaScript.

Coggle requires JavaScript to display documents.

Data Base Security (Security (Encryption (involves the encoding of data to…

- - - - An encryption algorithm changes the original data (known as the plaintext). To decipher the data, the user supplies an encryption key to restore the encrypted data (known as the ciphertext) to its original (plaintext) format.
- - - - The user_account in the format 'username''hostname' is followed by the CREATE USER clause
      - The password is specified in the IDENTIFIED BY clause
  - - - named group of privileges
      - When a role is created, the DBMS grants the role to either the current user or current role
      - CREATE ROLE ISPManager;
        CREATE ROLE ISAdministrator WITH ADMIN CURRENT_ROLE;
  - - - UPDATE
        
        Modify the value
        
        Can be specified for individual columns
      - INSERT
        
        Add a new row;
        
        Can be specified for individual columns
      - SELECT
        
        Query the ogject
        
        Can be specified for individual columns
      - EXECUTE
        
        Execute the stored procedure
      - DELETE
        
        Delete a row;
        
        Can be specified for individual columns
      - TRIGGER
        
        Create a trigger on a specified table
      - REFERENCES
        
        Reference columns of a given table in integrity constraints