Class 2 | Week 14 | DAT601
FINAL CLASS
For this final class todd is discussing the requirements for our milestone 3 once again, in further details, he has suggested that sections of our SQL code is written into procedures. Procedures for Creating, Inserting and then procedures for each transaction required.
When referring to our SQL code within our document it is fine to refer to our SQL text file instead of writing them out in the document.
Within our SQL file I need to remember to separate my procedures with comments and clearly label each one.
Next we are going into Server permissions, users and logins. What's the difference between them?
GRANT
Grants are used to give permissions to specific operations concerning chosen element/s of the database, grants are given to specific users of the databases procedures and functions.
For our assignments we are creating users, todd suggested our users be given permission to view a 'view' of the database which pertains to the information they require access to.
Grants work well with views by giving users access to a view only.
A user must have EXECUTE permission to execute a stored procedure.
Securables & Principles
Principles represent the entities that security is applied to, Securables are the resources to which the SQL Server Database Engine authorization system regulates access.
A "Login" grants the principal entry into the SERVER.
A "User" grants a login entry into a single DATABASE.
REVOKE is used to revoke assigned permissions, this removes GRANTS entirely and DENY is used to DENY access to securables, this takes precedence over GRANTS but does not remove the GRANTS entirely.
The rest of our class time has been tasked to execute a tutorial where we are implementing grants into sql server in order to help understand them for implementing them into our assignment.
For this final class todd is discussing the requirements for our milestone 3 once again, in further details, he has suggested that sections of our SQL code is written into procedures. Procedures for Creating, Inserting and then procedures for each transaction required.
When referring to our SQL code within our document it is fine to refer to our SQL text file instead of writing them out in the document.
Within our SQL file I need to remember to separate my procedures with comments and clearly label each one.
Next we are going into Server permissions, users and logins. What's the difference between them?
GRANT
Grants are used to give permissions to specific operations concerning chosen element/s of the database, grants are given to specific users of the databases procedures and functions.
For our assignments we are creating users, todd suggested our users be given permission to view a 'view' of the database which pertains to the information they require access to.
Grants work well with views by giving users access to a view only.
A user must have EXECUTE permission to execute a stored procedure.
Securables & Principles
Principles represent the entities that security is applied to, Securables are the resources to which the SQL Server Database Engine authorization system regulates access.
A "Login" grants the principal entry into the SERVER.
A "User" grants a login entry into a single DATABASE.
REVOKE is used to revoke assigned permissions, this removes GRANTS entirely and DENY is used to DENY access to securables, this takes precedence over GRANTS but does not remove the GRANTS entirely.
The rest of our class time has been tasked to execute a tutorial where we are implementing grants into sql server in order to help understand them for implementing them into our assignment.
Comments
Post a Comment