DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: creating table on users schema

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    creating table on users schema

    Hi,

    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
    Posts
    353
    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