Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 22:29:17 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Maximum Limits of Users in Warehouse
From:   Coffing Christopher L

This has been a great thread... Thank you all for your interest and thoughts...

I will answer as many of the replys in this response as possible...

Yes... I am having the time of my life... This has been the greatest experience of my carreer and there is no end in sight.

I didn't think there were any other warehouses that would have this many users on the system. Thanks for sharing on what is currently out there.

The requirement is to have all users in the Air Force capable of accessing Air Force Knowledge Services whether they need it or not, so we cannot take the approach of adding the user on demand (so to speak). Good thought!

At this point we have a handful of power users that will have the capability to create tables and/or views... The majority of the users will be accessing the system via Web Intelligence or some other web base technologies. These user databases will be empty.

We are on V2R5.0.3.20 right now and we are currently using Roles and Profiles.

Our backups are using the NONEMPTY DATABASES option. (thanks for making that recommendation!)

Great point on minimizing the Public Access Rights. If we use roles will this still be a concern??? Hmmm...

No! Teradata Administrator is a great product (cudos Mike Dempsey) but my fingers would be nothing but powdered bone if I did these one at a time...

I have the dynamic SQL statements already to go once I start getting the usernames. Of course the usernames are all "first.middle.last". They continue to challenge me!!!

I will create a table with all of the usernames to be added and join to this table as part of my Dynamic SQL statement.

Really appreciate the heads up on the time it will take to create these users. This is very intense on the data dictionary and we do a lot of DD access for our ETL processes. We load 7x24 so our windows are small to get this accomplished. The batches will be small enough to manage. But that is a lot of small batches...

We have to audit all of the users in the system to keep track of what our users are looking at and such, so we cannot use a single or shared logins for the app servers. Bummer!

Active Directory is an option for our Business Objects and Cognos servers I believe so our satalite servers may not have to deal with this issue like the "now humble" Teradata DBA...

Security, Logging and just about everything else gets to be a real big deal when you are managing 750,000 users so I will keep you posted on what we decide...

We will have to manage security at several different levels, Data Warehouse, AF Portal and User Interface... Wow, I am getting tired just thinking about all this!

It comes down to "managing the technology" and hitting a few brick walls...

Thanks again for everyone's input...

I have enough to go on for now...

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023