Post reply

One account for many databases?

  • November 23, 2009 at 5:35 pm

    #206705

    Most of our databases are for OLTP and we assign a single login\user to access that database. The name of that user contains the name of the database. We are now exploring OLAP databases and need to run queries that span multiple databases. The queries would fail if we continued the OLTP practice of assigning each database a unique user name (because the query can only run under one security context.)

    We could just say "that all databases belonging to this line of business, and application, can be accessed using this single account". Hope no one every cracks that single accounts for they would then have access to all the databases in the LOB!

    How do you deal with this issue.

    TIA,

    barkingdog

  • November 29, 2009 at 2:37 pm

    #1085171

    You can create a generic user and add that user into every database needed by OLAP system.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • November 29, 2009 at 8:36 pm

    #1085217

    Ummmm.... I haven't used them in SQL Server but wouldn't synonymns do the trick here?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 7, 2009 at 7:48 pm

    #1088977

    If you are looking at OLAP are we to assume SSAS or equivalent? Are you going to be building that directly from the operational systems?

    CEWII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply