creating table on users schema Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: creating table on users schema

  1. #1
    Join Date
    Nov 2001

    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.
    J Gangadhar

  2. #2
    Join Date
    Apr 2003
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width