From: Richard Huxton <dev@archonet.com>
To: Ramasamy <ramasamy.p@gmail.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: security for row level but not based on Database user's
Date: Tue, 25 Apr 2006 11:40:13 +0100
Message-ID: <444DFC8D.9060801@archonet.com> (raw)
In-Reply-To: <dd5258f00604250300h2550e7b2w19bb9310bf89510f@mail.gmail.com>
References: <1145615328.300612.56380@e56g2000cwe.googlegroups.com>
<444DEE78.7020703@archonet.com>
<dd5258f00604250300h2550e7b2w19bb9310bf89510f@mail.gmail.com>
Ramasamy wrote:
> Hi Richard ,
> Very good Day. Great information that you given to me.
Great glad you think it's useful. Oh, don't forget to cc: the
mailing-list - that's the convention around here.
> I will try in your idea. Here I am using SQL server 2000(Even I can use SQL
> Sever 2005 too if needed.) We are dealing with lot of databases with lot of
> business logic. I think your information will great for me.
Ah - you're not using PostgreSQL? Well, the principle is the same but
you should be aware that this is a PostgreSQL list so the details will
be different.
> Let I try and I will back with you.
>
> Thanks and hands of too you.
>
> But i don't have any idea of getting Session from databases (I think you are
> meaning that user can be handle with session). If you have some more idea
> then it will be great full to me.
With MS-SQL you'll probably want to look at T-SQL variables, although I
don't know if they last longer than a single transaction. Failing that,
functions or temporary tables might be a help.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, ramasamy.p@gmail.com
Subject: Re: security for row level but not based on Database user's
In-Reply-To: <444DFC8D.9060801@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox