Re: Constraining table to 1 record

1. Create a schema for the table (you don't have to create a user, just a schema)
2. Give an INSERT and SELECT grant to your regular login.
3. Insert the single row.
4. Revoke the INSERT grant.

Your normal login will be able to read the table, but not insert into it. Thus it will be limited to a single row.

Ken

Brian Howard wrote:

> What is the easiest way to constrain a table to 1 record only. I have a
> table that needs only a single entry. I am using Designer 2.1.2 and
> Developer Forms 5.
Received on Tue Aug 17 1999 - 20:46:35 CEST