creating table on users schema
I have dba privs got request from developer saying that
create table fin_mod(fina_amt varchar(6),finc_pct varchar(3)) on schema
finance but i donot know the passowd to connect to that schema to
connect and create a table. How should i proceed for this request.
With dba privilege, u can create with the following command
create table finance.fin_mod(fina_amt varchar(6),finc_pct varchar(3))
Give the above command connected as dba.
Click Here to Expand Forum to Full Width