Re: Help with user accounts

From: John Harbison (JohnH_at_desertmicro.net)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 13:05:43 -0500

To add more clarification:

Lets assume I have the following tables:

CUSTOMER:

ID CUSTOMER_NAME COMPANY
=====================================================================
1 Customer 1 1
2 Customer 2 1
3 Customer 3 1
4 Customer 4 2
5 Customer 5 2
6 Customer 6 2
7 Customer 7 1
8 Customer 8 2
9 Customer 9 2
10 Customer 10 2

USERS:

ID USER_NAME
=======================================
1 User 1
2 User 2
3 User 3
4 User 4

COMPANY:

ID COMPANY_NAME
==========================================
1 Company 1
2 Company 2

SECURITY:

USERID COMPANY_ID
========================================
1 1
1 2
2 1
3 2
4 1
4 2

Ok the application would know that if User 4 is pulling a list from the
CUSTOMER table to show the customers for both companies. Likewise if User 2
preformed the same action they should only see customers from Company 1.

My question is how to I get this same functionality from say Query Analyzer?

"John Harbison" <JohnH@desertmicro.net> wrote in message
news:eZH9VUcwEHA.3528@tk2msftngp13.phx.gbl...
> Is there a way to filter at the server level what data is returned to
> clients by user? I know that I can create a user account and assign what
> columns/tables the user account has access to, but what if I want them to
> have full access to a table, but only certain records in that table. Any
> ideas?
>
>

Relevant Pages

  • Re: Locking the failed login attemp
    ... > Is there anyway to lock a user account after, say 3, failed login attempts? ... > what the customer wants. ... lock them all out. ...
    (comp.unix.solaris)
  • Re: access to dbms_fga package on shared server
    ... each customer has an Oracle user/schema. ... ONE user account which  can access these user objects what good does ... granting access to this package. ... I think the customer needs to create an audit log of actions performed ...
    (comp.databases.oracle.server)
  • Re: Default User Site
    ... every user has to have a user account on the Domain or be ... If you want some sort of automated redirect from the ... user account for that customer in it. ... points to their customer site and set it to only the customer audience. ...
    (microsoft.public.sharepoint.portalserver)
  • Strange Problem need help!!
    ... CSM for SMB V2. ... One of the customers clients can not send email to my customer, ... The user account is NOT ...
    (microsoft.public.windows.server.sbs)
  • Re: My Frustrations
    ... Again, this is not an issue of communication, or geeks versus business men. ... This is not an issue of proving or demonstrating the quality of ones self or service. ... This is an issue of enabling the customer to make the right decision. ... landing the customer in a very poor security state, ...
    (Pen-Test)