Useful SQL Statements

• Grant CONNECT to userid identified by password; (creates new user)

• Alter user userid identified by password; (changes password)

• Grant DBA to userid; (gives user DBA privilege)

• Drop user userid cascade; (deletes userid and all objects created by userid)

Previous slide

Next slide

Back to first slide

View graphic version