Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Who designs universes.
- Thread starter mssplr
- Start date
jimbopalmer
Programmer
[the following is my opinion] I designed my initial universes by printing out all the reports the users had requested so far and making sure those requests were objects in BO. So I was acting as the Application Developer. Universe Designer is the only role in BO that HAS to be someone Technical, usually in IS. His (her) job is to de-mystify the SQL so the end users can write reports.
On The Other Hand, ALL my users HAVE designer, with no save abilities, so they can explore and learn HOW their Universe works. (Two of my end users have learned SQL and joined IS by using the SQL Button in the Data Provider screen and Designer without Save to learn the SQL language)
My one IS trick to 'secure' BO is this, grant select on all your desired tables in all tablespaces to BO, then create synonyms for those grants. All the tables LOOK Like BO owns them, but NONE can be changed, even in free hand SQL. I tried to remain child-like, all I acheived was childish.
On The Other Hand, ALL my users HAVE designer, with no save abilities, so they can explore and learn HOW their Universe works. (Two of my end users have learned SQL and joined IS by using the SQL Button in the Data Provider screen and Designer without Save to learn the SQL language)
My one IS trick to 'secure' BO is this, grant select on all your desired tables in all tablespaces to BO, then create synonyms for those grants. All the tables LOOK Like BO owns them, but NONE can be changed, even in free hand SQL. I tried to remain child-like, all I acheived was childish.
- Status
Similar threads
- Locked
- Question