Basic Commands for Oracle 10g

by **BIT0119-Asif** Mon Jul 12, 2010 1:38 am

1) Select db: desc dba_tablename;

2) Connect: conn sys/'password' as sysdba;

3) Show: show user;

4) Alter user: alter user 'usename' identified by 'password';

5) Unlock user: alter user 'username' account unlock;

6) lock user: alter user 'username' account lock;

7) create user: create user 'username' identified by 'password';

Cool

grant login to newly created user: grant create session to 'username';

by **BIT0122-Amit** Mon Jul 12, 2010 2:28 am

hmm...

rep++
um... was not there some another command related to grant?

by **BIT0122-Amit** Mon Jul 12, 2010 2:30 am

and what means alter user? Neutral

by **BIT0129-Tabassum** Mon Jul 12, 2010 3:04 am

Nice post Asif..Thanks a lot Very Happy

Hoping we will see more and descriptive commands from you Smile

by **BIT0108-mostafa** Mon Jul 12, 2010 4:12 am

nice work chattor...........

by **BIT0107-Toma** Tue Jul 13, 2010 1:21 am

@Amit: alter means that u r moving from one user to another. that means user switching. I think only sysdba can do this.

by **BIT0122-Amit** Tue Jul 13, 2010 2:16 am

BIT0107-toma wrote:@Amit: alter means that u r moving from one user to another. that means user switching. I think only sysdba can do this.

erm....

means... I am logged in from sys as sysdba
and by using alter, i will be able to login as toma (which is a user)

So, that means I will have only user level privileges, right?

rep++ btw Smile

by Sponsored content

Basic Commands for Oracle 10g

Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g

Re: Basic Commands for Oracle 10g