[Q] CREATE USER via Forms V4.0?

From: Byron Pearce <bpearc1_at_abacus.tis.tandy.com>
Date: 6 Jan 1995 03:18:17 GMT
Message-ID: <3eicpp$5mu_at_abacus.tis.tandy.com>

I am trying to create a DB Admin tool via SQL*Forms V4.0 that will help maintain database accounts. However, when I try and execute the 'CREATE USER :B_block.username;' syntax within a PL/SQL procedure it fails to compile. Even hard-coding a name (i.e. 'CREATE USER jdoe1;') does not work.

I am at a loss (being a DBA and not a SQL*Forms designer). Can you not execute SQL syntax from within a SQL*Forms procedure or am I just missing something? Any help is greatly appreciated.

---

Byron Pearce                        |  The thoughts and views herein do not
Tandy Information Services          |  necessarily reflect that of Tandy
byron.pearce_at_tandy.com              |  Corporation.
------------------------------------------------------------------------------

"It's hard to be a ninja when you wear a beeper."

---

Received on Fri Jan 06 1995 - 04:18:17 CET