SQL create username identified by password EX SQL
![](https://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-1.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-2.jpg)
![: • ﻻﻧﺸﺎﺀ ﻣﺴﺘﺨﺪﻡ ﺟﺪﻳﺪ • SQL> create user_name identified by password ; • : • ﻻﻧﺸﺎﺀ ﻣﺴﺘﺨﺪﻡ ﺟﺪﻳﺪ • SQL> create user_name identified by password ; •](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-3.jpg)
: • ﻻﻧﺸﺎﺀ ﻣﺴﺘﺨﺪﻡ ﺟﺪﻳﺪ • SQL> create user_name identified by password ; • EX: SQL> create user asma identified by sss 2011 ; User created
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-4.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-5.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-6.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-7.jpg)
![System privileges Connect Resource DBA Access the Oracle database , create tables, create sequence, System privileges Connect Resource DBA Access the Oracle database , create tables, create sequence,](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-8.jpg)
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 Default users User name scott System sys demo PO 7 Password Privilege tiger Connect](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-9.jpg)
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 • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻜﺎﺋﻨﺎﺕ • ﻟﺴﺤﺐ ﺍﻟﺼﻼﺣﻴﺎﺕ ﻳﺴﺘﺨﺪﻡ ﺍﻻﻣﺮ Revoke : Object privileges • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻜﺎﺋﻨﺎﺕ •](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-10.jpg)
ﻟﺴﺤﺐ ﺍﻟﺼﻼﺣﻴﺎﺕ ﻳﺴﺘﺨﺪﻡ ﺍﻻﻣﺮ Revoke : Object privileges • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻜﺎﺋﻨﺎﺕ • SQL>revoke insert on T 1 from asma ; Revoke succeeded System privilege • ﻟﺴﺤﺐ ﺻﻼﺣﻴﺎﺕ ﺍﻟﻨﻈﺎﻡ • SQL> revoke resource from asma ; Revoke succeeded
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-11.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-12.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-13.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-14.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-15.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-16.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-17.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-18.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-19.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-20.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-21.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-22.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-23.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-24.jpg)
![](http://slidetodoc.com/presentation_image_h/2793fc61190707d87da4710bf21a704a/image-25.jpg)
- Slides: 25