SolveITProblems is a project of intellectual club

SolveITProblems это проект интеллектуального клуба

среда, 25 апреля 2012 г.

Creating new a user (schema) on Oracle Database

Imagine you have sysadm access to the Oracle database and you need to create a new user with his own schema. You need to run just 2 queries:

CREATE USER username IDENTIFIED BY username //Create user "username" with password "username"
GRANT ALL PRIVILEGES to username // grant all privileged, so now you can connect and create your databases

Enjoy :)

Комментариев нет:

Отправка комментария