1 / 8

Login dan Permission

Login dan Permission. Jenis Login. SQL Server Authentication Membutuhkan password Windows Authentication Mode Tidak membutuhkan password. CREATE LOGIN. CREATE LOGIN loginName { WITH <option_list1> | FROM <sources> } < option_list1> ::=

oren-william
Download Presentation

Login dan Permission

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Login dan Permission dfd, 2012

  2. Jenis Login • SQL Server Authentication Membutuhkan password • Windows Authentication Mode Tidakmembutuhkan password dfd, 2012

  3. CREATE LOGIN • CREATE LOGIN loginName { WITH <option_list1> | FROM <sources> } <option_list1> ::= PASSWORD = { 'password' | hashed_password HASHED } [ MUST_CHANGE ] [ , <option_list2> [ ,... ] ] <option_list2> ::= SID = sid| DEFAULT_DATABASE =database | DEFAULT_LANGUAGE =language | CHECK_EXPIRATION = { ON | OFF} | CHECK_POLICY = { ON | OFF} | CREDENTIAL =credential_name <sources> ::= WINDOWS [ WITH <windows_options>[ ,... ] ] | CERTIFICATE certname | ASYMMETRIC KEY asym_key_name <windows_options> ::= DEFAULT_DATABASE =database | DEFAULT_LANGUAGE =language dfd, 2012

  4. ALTER LOGIN • ALTER LOGIN login_name { <status_option> | WITH <set_option> [ ,... ] | <cryptographic_credential_option> } <status_option> ::=ENABLE| DISABLE <set_option> ::=            PASSWORD ='password' | hashed_password HASHED [ OLD_PASSWORD ='oldpassword' | <password_option> [<password_option> ] ] | DEFAULT_DATABASE =database | DEFAULT_LANGUAGE =language   | NAME =login_name | CHECK_POLICY = { ON | OFF } | CHECK_EXPIRATION = { ON | OFF } | CREDENTIAL =credential_name | NO CREDENTIAL    <password_option> ::= MUST_CHANGE | UNLOCK <cryptographic_credentials_option> ::= ADD CREDENTIAL credential_name | DROP CREDENTIAL credential_name dfd, 2012

  5. CREATE USER USE namadatabase CREATE USER namauser FOR LOGIN namalogin dfd, 2012

  6. DROP LOGIN DROP LOGIN login_name dfd, 2012

  7. GRANT Database Permissions GRANT <permission> [ ,...n ] TO <database_principal> [ ,...n ] [ WITH GRANT OPTION ] [ AS <database_principal> ] <permission>::= permission | ALL [ PRIVILEGES ] <database_principal> ::= Database_user | Database_role | Application_role | Database_user_mapped_to_Windows_User | Database_user_mapped_to_Windows_Group | Database_user_mapped_to_certificate | Database_user_mapped_to_asymmetric_key | Database_user_with_no_login dfd, 2012

  8. REVOKE REVOKE nama_hak_akses ON OBJECT::nama_tabel FROM nama_user contoh: use namadatabase REVOKE SELECT ON OBJECT::pegawai FROM saya dfd, 2012

More Related