STEPS:- 1. open command prompt 2. login into sqlplus with user: sqlplus sys/password as sysdba 3. create a user using sql command SYNTAX: CREATE USER username IDENTIFIED BY paswword DEFAULT TABLESPACE tablespacename TEMPORARY TABLESPACE tablespacename QUOTA 5M ON USER ACCOUNT lock/unlock; or CREATE USER username IDENTIFIED BY paswword 4. give system privileges GRANT CREATE SESSION, CREATE TABLE TO username; 5. login to user using SQL developer and sqlplus now login into sys user in sql developer 6. droping user which is connected to database follow the step - login into sys user with admin mode - ALTER SYSTEM ENABLE RESTRICTED SESSION - SELECT sid,serial# FROM V$SESSION WHERE username='clerk'; (OR) SELECT * FROM V$SESSION; - ALTER SYSTEM KILL SESSION 'sidno','serial#no'; - DROP USER username CASCADE; we cant find the user because the user clerk is dropped. Thank you for watching Blog:- http://ramprasath91.blogspot.com Facebook:- https://www.facebook.com/Ramprasath.tamil LinkeIn:- https://in.linkedin.com/pub/ramprasath-d/80/3b0/a22
Views: 622 TechWizard
Watch in HD,Dropping a user is easy only when it is not connected to the database what if it is connected. Learn how to drop a user when it is connected to the database as well as when it is not connected, along with the cascade drop and introduction of Startup RESTRICT mode of Oracle database. ------------------------- Topics cover 1. Drop user when it is not connected to the database 2. Drop user cascade 3. Drop user when it is connected to the database 4. How to kill a session 5. Oracle Start-up Restrict 6. What is Restrict Start-up and why we use it. Please please LIKE and SHARE my videos it makes me happy. Links: Detail Blog (Must Read) http://bit.ly/drop-user Tutorial 38 Create user using SQL Developer http://youtu.be/GS4udgR44Ls Tutorial 37 Create user using SQL create user statement http://youtu.be/4QbK2Y-1LZw Tutorial 39 create user using EM http://youtu.be/zGjh-Bb3HrI Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Follow What I am up to as it happens on Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 21435 Manish Sharma
Watch Episode 1 of A.I.SHA My Virtual Girlfriend - An Arre Original Web Series. Sam, a 26-year old app developer, is excited about his new music app presentation at Future Lens, the company he works for. But his boss from hell, Sid, will not let him have his day. Meanwhile, Sam, a loner and a socially awkward genius has been creating his own perfect A.I app in secret. What will happen when Sid finds out? Season 2 - Episode 1 Live Now : https://youtu.be/-HUCg_b5Drg Cast: Raghu Ram (@tweetfromRaghu) www.facebook.com/Spotlight.RaghuRam Harman Singha (@SinghaHarman) www.facebook.com/harman.singha Auritra Ghosh (@AuritraGhosh) www.facebook.com/auritra.ghosh.3 Adesh Sidhu (@adesh_sidhu) www.facebook.com/adesh.sidhu.7 Flora Saini (@FLOR_AAH) www.facebook.com/iamflorasaini Website: https://www.arre.co.in Like us @ https://www.facebook.com/ArreIndia Instagram us @ https://www.instagram.com/arreindia/ Follow us @ https://twitter.com/ArreTweets
Views: 2316626 Arré
Watch interviews, gameplay, and panel discussions live from PSX 2017, includes updates on The Last of Us Part II, Ghost of Tsushima, Dreams, Monster Hunter: World, and much more. See the full programming schedule at http://playstation.blog and http://twitter.com/playstation.com.
Views: 402269 PlayStation