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