Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread hari . fuchs
Andreas writes: > Hi, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-managers. > Could I limit account-manager #1 so that he only can access customers > only acording to a flag? Maybe something like the followin

Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread Jayadevan M
HI, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-managers. > Could I limit account-manager #1 so that he only can access customers > only acording to a flag? > > Say I create a relation cu_am ( customer_id,

Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread Jov
no,I think there is no such way. what about create view for the user you want to limit,and revoke select privilege from the base table ? 2012/6/22 Andreas > Hi, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-ma

Re: [SQL] How to limit access only to certain records?

2012-06-22 Thread Andreas Kretschmer
Andreas wrote: > Hi, > > is there a way to limit access for some users only to certain records? > > e.g. there is a customer table and there are account-managers. > Could I limit account-manager #1 so that he only can access customers > only acording to a flag? Yea, it's possible. Write funct

[SQL] How to limit access only to certain records?

2012-06-22 Thread Andreas
Hi, is there a way to limit access for some users only to certain records? e.g. there is a customer table and there are account-managers. Could I limit account-manager #1 so that he only can access customers only acording to a flag? Say I create a relation cu_am ( customer_id, account_manage