Roman Simakov wrote Fri, 04 Jul 2014 17:23:38
+0300:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
> Patch was discussed with Dmitry Yemanov, Alex Peshkoff and Vlad Khorsun.
> Small descrip
Alex Peshkoff wrote Sun, 17 Aug 2014 13:00:52 +0400:
>
> Denis, please add a ticket to the tracker.
>
OK.
http://tracker.firebirdsql.org/browse/CORE-4522
--
Simonov Denis
--
Firebird-Devel mailing list, web interfac
On 08/16/14 18:07, Simonov Denis wrote:
> Roman Simakov писал(а) в своём письме Fri, 04
> Jul 2014 18:23:38 +0400:
>
>> Hello!
>>
>> I'd like to present a patch for firebird trunk which implements
>> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>>
>> Patch was discussed w
Roman Simakov писал(а) в своём письме Fri, 04
Jul 2014 18:23:38 +0400:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
> Patch was discussed with Dmitry Yemanov, Alex Peshkoff and Vlad Khorsu
> -Original Message-
> From: Dmitry Yemanov [mailto:firebi...@yandex.ru]
> Sent: Sábado, 02 de Agosto de 2014 12:15
>
> 01.08.2014 18:55, Simonov Denis wrote:
>
> > SQL> insert into RDB$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1');
>
> At the first glance, I don't see why it cannot be p
Dmitry Yemanov wrote Sat, 02 Aug 2014 20:14:38 +0400:
> 01.08.2014 18:55, Simonov Denis wrote:
>
>> SQL> insert into RDB$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1');
Note that I did this unprivileged user!
>
> At the first glance, I don't see why it cannot be prohibited. But I see
> from the c
01.08.2014 18:55, Simonov Denis wrote:
> SQL> insert into RDB$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1');
At the first glance, I don't see why it cannot be prohibited. But I see
from the code that many system tables are still unprotected from user
inserts. Maybe Claudio still has some pending
2014-08-01 18:55 GMT+04:00 Simonov Denis :
> DDL permissions is very good, but so far it is possible to modify the
> system tables are not useful enough. For some system tables is already
> banned, but some still allow some nastiness.
> A few simple examples:
Yes. Direct changing system tables wa
Roman Simakov wrote Fri, 04 Jul 2014 18:23:38
+0400:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
> I'm ready to answer any questions.
>
> I'd like to commit it. Opinions?
>
DDL permissio
Roman Simakov wrote, 04 Jul 2014 18:23:38
+0400:
In doc/sql.extensions/README.ddl_access.txt write
Where could be:
TABLE, VIEW, PROCEDURE, FUNCTION, PACKAGE, GENERATOR, SEQUENCE, DOMAIN,
EXCEPTION, ROLE, SHADOW, DATABASE, CHARACTER SET, COLLATION, FILTER
.
h
Dmitry Yemanov wrote Thu, 17 Jul 2014 17:58:59 +0400:
> 17.07.2014 12:32, Simonov Denis wrote:
>
>
> Two workarounds are possible:
>
> (1)
> gsec -user sysdba -pass masterkey
> GSEC> add sysdba -pw masterkey
>
> or
>
> (2)
> isql -user sysdba employee
> SQL> create user sysdba password 'masterkey
17.07.2014 12:32, Simonov Denis wrote:
> After adding restrictions on DDL statements, I can not start initialized
> security3.fdb
>
> GSEC> add sysdba -pw masterkey
> An error occurred while attempting to add the user.
> unsuccessful metadata update
> CREATE TABLE PLG$SRP failed
> There is no priv
Roman Simakov wrote, 04 Jul 2014 18:23:38
+0400:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
After adding restrictions on DDL statements, I can not start initialized
security3.fdb
GSE
Hi Roman,
On 14 July 2014 08:37, Roman Simakov wrote:
>
> I do not think that separate operators for these are good. It can lead
> to inconsistence like "user has permissions on object but cannot see
> it".
>
>
Actually, that is preferred. For developers and power users, we can
appreciate seei
2014-07-14 16:22 GMT+04:00 Dalton Calford :
> It would be nice if there was an option for visibility ie
>
> GRANT VISIBLE FOR TO [USER|ROLE]
> [with grant option];
>
> REVOKE VISIBLE FOR FROM [USER|ROLE] ;
>
> With a default of all things being visible to maintain backwards
> compatibility, bu
It would be nice if there was an option for visibility ie
GRANT VISIBLE FOR TO [USER|ROLE]
[with grant option];
REVOKE VISIBLE FOR FROM [USER|ROLE] ;
With a default of all things being visible to maintain backwards
compatibility, but, allowing the developer to remove sql objects from being
2014-07-14 10:18 GMT+04:00 Simonov Denis :
> I think it is more correct to describe it as
Agreed.
--
Roman Simakov
--
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of
Roman Simakov wrote Fri, 04 Jul 2014 18:23:38
+0400:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
> Patch was discussed with Dmitry Yemanov, Alex Peshkoff and Vlad Khorsun.
> Small descrip
Hi, Mark!
Thanks for your reply:
2014-07-05 10:30 GMT+04:00 Mark Rotteveel :
> I have not checked the code thoroughly, but I noticed two things:
> 1) there are still some TODOs in the code
Yes. The main part is done. The rest one is about user management
which will be implemented a bit later wit
On 5-7-2014 08:30, Mark Rotteveel wrote:
> For 2 (entirely based on the name), I'd propose:
> * dyn_no_priv (335545094): 42000 (syntax error or access rule violation)
>
> * dsql_cant_grant_option (336397330) : 42000 (syntax error or access
> rule violation), I had hoped there was a closer one, but
On 4-7-2014 16:23, Roman Simakov wrote:
> Hello!
>
> I'd like to present a patch for firebird trunk which implements
> http://tracker.firebirdsql.org/browse/CORE-735 like Red Database does.
>
> Patch was discussed with Dmitry Yemanov, Alex Peshkoff and Vlad Khorsun.
> Small description you can find
21 matches
Mail list logo
