Please enable JavaScript.

Coggle requires JavaScript to display documents.

Security (Autoryzacja (Database (Stored Procedure (GRANT EXECUTE, VIEW…

- - - - GRANT EXECUTE
      - VIEW DEFINITION
    - - np. GRANT SELECT
      - Column Level Security
  - - - Alter
      - Control
  - - - lowest level
    - - second level
      - remove grant and deny
- - - - SQL Server
      - Windows
- - - - db_owner
        
        full controle
      - db_datareader
        
        only reader
      - db_datawriter
        
        write data
      - db_denydatareader
        
        overwrite #
      - db_denydatawriter
        
        overwrite
      - db_backupoperator
      - db_ddladmin
        
        create object
      - public
      - db_securityadmin
        
        add permiission for user
      - db_accessadmin
        
        add user to db
    - - CREATE ROLE
        
        GRANT
        
        DENY
        
        REVOKE