Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on creation of a table
The other 2 answers look fine to me. However, You might consider, if this is
one of many similar problems you have,trying this from a DBA rather than
developer view.
a) Put the table in a read only tablespace.
b) Create the table under one specific schema and only grant select on the
table to users. To increase security you could also lock the schema
account - alter user identified by values ('a'); This will not stop system
user accounts updating the table but if the db is designed correctly, the
security should already be in place and daft users with dba privs can wreck
your app anyway..
arunal_at_hotmail.com wrote in message <784793$pu9$1_at_nnrp1.dejanews.com>...
>Hi all, I want to create a table with only one record. While creating the
>table using create table command itself i want to include some
>condition/constraint which restricts the table to contain only one row. Has
>anyone come across such a situation. If so please let me know. Any help in
>this regard is greately appreciated. thanx in advance regards aruna
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Jan 20 1999 - 14:42:09 CST
![]() |
![]() |