Great) So we just need to adjust documentation?
вс, 9 мая 2021 г. в 20:05, Mark Rotteveel :
>
> On 09-05-2021 18:38, Roman Simakov wrote:
> > Create a ticket, please: drop clauses for procedures, functions and
> > packages and inheriting a clause for packages.
>
> Currently, an alter, create or al
09.05.2021 19:22, Adriano dos Santos Fernandes wrote:
Can it be used to create links to individual libraries (putting links in
standard directories)?
According to the man page which link I posted above - yes.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.source
On 08/05/2021 12:12, Dimitry Sibiryakov wrote:
> 08.05.2021 16:51, Alex Peshkoff via Firebird-devel wrote:
>> Does all that mean that we have problems finding a directory where to
>> create soft link to fbclient?
>> If yes - do you have suggestion how to find that (primary lib)
>> directory better?
On 07/05/2021 12:23, Alex Peshkoff via Firebird-devel wrote:
> On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote:
>> What I want to ask about if it's clear/good is that DefaultTimeZone set
>> in client does not implicitly pass isc_dpb_session_time_zone in the
>> attachment.
>
> For me such beh
On 09-05-2021 18:38, Roman Simakov wrote:
Create a ticket, please: drop clauses for procedures, functions and
packages and inheriting a clause for packages.
Currently, an alter, create or alter or recreate without a SQL SECURITY
clause will implicitly drop it for procedures, functions and pack
Create a ticket, please: drop clauses for procedures, functions and
packages and inheriting a clause for packages.
вс, 9 мая 2021 г. в 19:35, Mark Rotteveel :
>
> On 09-05-2021 18:24, Roman Simakov wrote:
> > вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
> >> Does that mean that the ALTER DATABASE S
On 09-05-2021 18:24, Roman Simakov wrote:
вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
Does that mean that the ALTER DATABASE SET DEFAULT SQL SECURITY
influences all objects without an explicit SQL SECURITY property?
I've checked. It influences tables, functions and procedures. Triggers
inheri
On 09-05-2021 18:02, Dimitry Sibiryakov wrote:
09.05.2021 18:00, Mark Rotteveel wrote:
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if
the input is a non-BLOB type, is that intentional, o
вс, 9 мая 2021 г. в 19:04, Mark Rotteveel :
>
> On 09-05-2021 17:58, Roman Simakov wrote:
> > I guess this was the reason not to implement it. But objects inherit
> > SQL SECURITY from the database and it might be useful to drop sql
> > security in order to use database default.
>
> Does that mean
On 09-05-2021 18:03, Mark Rotteveel wrote:
Does that mean that the ALTER DATABASE SET DEFAULT SQL SECURITY
influences all objects without an explicit SQL SECURITY property?
I had assumed it would specify the default for creating a new object
(similar as SET DEFAULT CHARACTER SET). Can you con
On 09-05-2021 17:58, Roman Simakov wrote:
вс, 9 мая 2021 г. в 18:46, Dmitry Yemanov :
What is the point in dropping, if AFAIU the legacy (lacking sql
security) mode is actually the same as "definer"?
I guess this was the reason not to implement it. But objects inherit
SQL SECURITY from the da
09.05.2021 18:00, Mark Rotteveel wrote:
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a
non-BLOB type, is that intentional, or is this a bug?
VARBINARY is an alias of V
On 09-05-2021 17:54, Dimitry Sibiryakov wrote:
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if
the input is a non-BLOB type, is that intentional, or is this a bug?
VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference
On 09-05-2021 17:45, Dmitry Yemanov wrote:
09.05.2021 18:25, Roman Simakov wrote:
I don't remember why I did so but maybe it's better to allow drop sql
security for any object type and remove the wrong statement at all.
What is the point in dropping, if AFAIU the legacy (lacking sql
security
вс, 9 мая 2021 г. в 18:46, Dmitry Yemanov :
> What is the point in dropping, if AFAIU the legacy (lacking sql
> security) mode is actually the same as "definer"?
I guess this was the reason not to implement it. But objects inherit
SQL SECURITY from the database and it might be useful to drop sql
09.05.2021 17:48, Mark Rotteveel wrote:
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the input is a
non-BLOB type, is that intentional, or is this a bug?
VARBINARY is an alias of VARCHAR CHARACTER SET NONE. The difference is
subtype only.
--
WBR, SD.
Firebird-Deve
According the Firebird 4.0 Release Notes, the return type of the DECRYPT
and ENCRYPT functions is:
"""
Functions return BLOB when the first argument is blob and varbinary for
all text types.
"""
However the return type of DECRYPT is VARCHAR CHARACTER SET NONE if the
input is a non-BLOB type,
09.05.2021 18:25, Roman Simakov wrote:
I don't remember why I did so but maybe it's better to allow drop sql
security for any object type and remove the wrong statement at all.
What is the point in dropping, if AFAIU the legacy (lacking sql
security) mode is actually the same as "definer"?
I don't remember why I did so but maybe it's better to allow drop sql
security for any object type and remove the wrong statement at all.
вс, 9 мая 2021 г. в 17:07, Mark Rotteveel :
>
> The 'SQL SECURITY Feature' section of the Firebird 4.0 Release Notes has
> a contradictory statement. It says:
>
The 'SQL SECURITY Feature' section of the Firebird 4.0 Release Notes has
a contradictory statement. It says:
"""
The property cannot be dropped but it can be changed from INVOKER to
DEFINER and vice versa.
"""
However, the syntax explicitly includes `DROP SQL SECURITY` for `ALTER
TABLE` and
20 matches
Mail list logo
