MSSQL Authorizing Securable

Securable(s) are objects (for example, tables, views, stored procedures, and columns) that can be secured in order to prevent unauthorized access. If a user has access to the database, then permission to the individual database objects may be granted.
Permission may be granted either directly to the user or to a standard role and the user assigned to the role. Users may be assigned to multiple roles, so multiple security paths from a user to an object may exist.

-Several specific types of permissions exist: Select Insert, Update, Delete, DRI, and Execute. Object permissions are assigned with the SQL DCL commands, GRANT, REVOKE, and DENY. It’s essential to secure the database objects. This is an integral part of the SQL Server security model.

Leave a Reply

Your email address will not be published. Required fields are marked *