Re: Questions on setup and usage

Поиск
Список
Период
Сортировка
От Michael Gould
Тема Re: Questions on setup and usage
Дата
Msg-id 87caf68661ef4cc6290857b748030ce9@intermodalsoftwaresolutions.net
обсуждение исходный текст
Ответ на Re: Questions on setup and usage  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
I know that by using lowercase object names that I can work with those
object in a case insensitive way, however is there a way through maybe a
locale or character set to make the data and the indexes case insensitive
such that you don't need to use ILIKE?

Best Regards

Michael Gould



"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> Michael Gould <mgould@intermodalsoftwaresolutions.net> wrote:
>
>> 1.  The ability to encrypt stored procedures and triggers.  I know
>> that PostGres doesn't have this feature but is there a way to
>> protect stored procedure and trigger source yet allow it to be
>> executed by any user and how would it be done.
>
> You could code them in a compiled language (like C) and the user would
> only see a reference to the library file.
>
>> 2.  We do not want the table schema to be accessed by outside
>> applications.  Since our application is so normalized, accessing
>> these tables directly will not make a lot of sense to our users so
>> we create views that are more user friendly for doing reports,
>> accessing the data via Excel, etc.  How would we do this in
>> Postgres.
>
> You could put the tables in a separate schema, which you would not put
> on the default search path.  The views could refer to the tables with
> the schema qualifier.  This would not hide the tables from the users,
> per se, but would cause them not to show on casual display, or allow
> them to be accessed without explicitly specifying the schema.
>
>> 3.  We use active directory to validate a user's login.  We have
>> "rules" and functionality security built in as stored procedures.
>> How would we do this under Postgres.  We do this with a
>> configuration variable during the login process stored process.  If
>> the company uses active directory we use it to validate the user, if
>> not then we present a user login and require that a login be
>> manually entered.  For those companies that use active directory we
>> try to have our application validate the AD so that the user isn't
>> required to multiple applications.
>
> I don't know anything about that.  Perhaps someone else will jump in
> with advice.
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax



В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Questions on setup and usage
Следующее
От: Andy Shellam
Дата:
Сообщение: Re: Compile errors when building 32-bit on 64-bit system