Unit 8 Research Assignment 1
1. Find out how MySQL manages basic authentication and authorization.
In the Microsoft SQL Server, authentication process occures when someone wanted to make a connection to Microsoft SQL Server. User and password is required for some one to be able to access resources of the Microsoft SQL Server. Once the authentication process finishes, Microsoft SQL Server takes control of authorizing user’s can access to object ( Database, table, trigger and function ) and data in the system
Ref :http://security.widyani.com/sql-server-security/basic-microsoft-sql-server-security.html
2. Find out how Microsoft Access manages basic authentication and authorization.
Authentication
All calls to IIS Smooth Streaming Management REST Services are authenticated through the HTTP authentication mechanisms supported by IIS. IIS 7 supports Basic authentication, Client Certificate Mapping authentication, Digest authentication, IIS Client Certificate Mapping authentication, and Windows authentication (Negotiate and NTLM). (IIS 7 also supports Anonymous authentication, but Anonymous authentication is explicitly blocked for REST services APIs). All operations are authenticated. Anonymous calls are rejected with an HTTP 401 (Unauthorized) status code even when Anonymous authentication is enabled.
Non-domain and non-Windows clients can call the services if they use standard HTTP authentication mechanisms and if Windows credentials are provided. In addition, client certificate mapping can be used in order to map generic certificates to Windows user accounts. For more information,
Authorization
IIS Smooth Streaming Management REST Services authorization is performed by checking user access rights to the publishing point (.isml) file. GET operations require read access to the publishing point file. PUT or DELETE operations require write access for the files. Creating a new publishing point using the POST operation