DBA haklari ile kullanıcı yaratma
Sunday, March 1, 2015
CREATE USER demo IDENTIFIED BY demo; -- create user with password GRANT CONNECT,RESOURCE,DBA TO demo; -- grant DBA,Connect and Resource permission to this user(not sure this is necessary if you give admin option) GRANT CREATE SESSION TO demo WITH ADMIN OPTION; --Give admin option to user GRANT UNLIMITED TABLESPACE TO demo; -- give unlimited tablespace grant
No comments :
Post a Comment