SQL create username identified by password EX SQL
: • ﻻﻧﺸﺎﺀ ﻣﺴﺘﺨﺪﻡ ﺟﺪﻳﺪ • SQL> create user_name identified by password ; • EX: SQL> create user asma identified by sss 2011 ; User created
System privileges Connect Resource DBA Access the Oracle database , create tables, create sequence, create procedure , trigger , index All system privileges • EX: SQL> Grant resource to asma ;
Default users User name scott System sys demo PO 7 Password Privilege tiger Connect and resource manager DBA sys Connect , resource , DBA, EXP_full_database, IMP_full_database demo Connect and resource PO 7 DBA
ﻟﺴﺤﺐ ﺍﻟﺼﻼﺣﻴﺎﺕ ﻳﺴﺘﺨﺪﻡ ﺍﻻﻣﺮ Revoke : Object privileges • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻜﺎﺋﻨﺎﺕ • SQL>revoke insert on T 1 from asma ; Revoke succeeded System privilege • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻨﻈﺎﻡ • SQL> revoke resource from asma ; Revoke succeeded
- Slides: 25