HomeЛюди и блогиRelated VideosMore From: Thamizharasan Mohan

How to create an user and to grant all privileges to them in Oracle database

128 ratings | 40795 views
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Html code for embedding videos on your blog
Text Comments (13)
Ndifor Pierre Che (2 months ago)
When i connect using sqlplus /as sysdba the message appear saying connected to ldle instance. I use the shutdown abort and startup back but still error coming up
Ndifor Pierre Che (2 months ago)
Please i can't connect to my database. The message said ORACLE NOT AVAILABLE
Nassir Maalej (5 months ago)
Anand Kumar (7 months ago)
We have to commit it right???
Priyanka Rauthan (9 months ago)
What is the password for system??
Sreekandan Narayanan (7 months ago)
Priyanka Rauthan pw: nith
evens noste (10 months ago)
Salut! Comment creer un trigger qui permet de transformer en majuscule les donnees saisir par un utilisateur.
Aniket Mandal (2 years ago)
Thank you. It actually helped me to get rid of this "ora-01031 insufficient privileges" error!!
Garrettx (3 years ago)
Error at 1 line: invalid common user or role name
Omar Key (4 years ago)
thank you sir 
Oscar Fernandez (5 years ago)
You can also use this instructions. grand dba to "username"; I don't really know if this give all the privileges, but work fine in order to connect, create tables. That's all I know at the moment.
abdu2s (5 years ago)
Thanks it worked fine
vairadevi arumugam (5 years ago)
Thank You Thamizh.!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.