Advanced Search

Return to Snippet

Revision: 16493
at August 6, 2009 06:17 by kamilch
Updated Code 
-- creates new user JOHN with 123456 password
-- and grants all privileges to him
CREATE user JOHN IDENTIFIED BY "123456" DEFAULT tablespace USERS;
GRANT ALL PRIVILEGES TO JOHN;

Revision: 16492
at August 6, 2009 06:07 by kamilch
Initial Code 
-- creates new user JOHN with 123456 password
-- and grants all privileges to him
CREATE user JOHN IDENTIFIED BY '123456' DEFAULT tablespace USERS;
GRANT ALL PRIVILEGES TO JOHN;
Initial URL 









Initial Description














Initial Title





Create new Oracle user









Initial Tags





Oracle









Initial Language





PL/SQL