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!
Row Level Security in DB2
- Thread starter viperrt10
- Start date
Hello viperrt10 ,
You will not get far with the notion of setting locks on data, this is dealed with by DB2 itself, based on performance issues. Marc's suggestion is the way to go, give them access to certain views which contain the data they are allowed to see. (But this may not be much of a help if they need read rights on the table in order to access the view, this you can easily test though).
(These sort of issues give me a warm feeling when I work with a good BI tool that lets you set up these restrictions through a semantic layer, instead of having to do everything at database level) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
You will not get far with the notion of setting locks on data, this is dealed with by DB2 itself, based on performance issues. Marc's suggestion is the way to go, give them access to certain views which contain the data they are allowed to see. (But this may not be much of a help if they need read rights on the table in order to access the view, this you can easily test though).
(These sort of issues give me a warm feeling when I work with a good BI tool that lets you set up these restrictions through a semantic layer, instead of having to do everything at database level) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
- Thread starter
- #4
- Thread starter
- #5
Hello viperrt10,
BI stand for business intelligence. The big ones are Business Objects,Cognos. There is a host of other products available from very professional to cheap-and dirty.
Personally I work with Business Objects which uses a semantic layer between the front-end (reporting module) and the source (database,flatfile,stored procedure, SQL)
I am a bit biased on this subject, so before I start doing a commercial for my favorite tool I'll try to give some sort of definition of what it does:
Reporting and analysis through graphical interface, presenting user with meaningful labeled objects, ensuring that user can create his own reports without specific knowledge of underlying data-structure or SQL with decent security set up to restrict data-access if needed.
Well, that was a definition "on the fly", but may give you some idea.
Biggest drawback of such nice tools is the initial cost of licenses........... T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
BI stand for business intelligence. The big ones are Business Objects,Cognos. There is a host of other products available from very professional to cheap-and dirty.
Personally I work with Business Objects which uses a semantic layer between the front-end (reporting module) and the source (database,flatfile,stored procedure, SQL)
I am a bit biased on this subject, so before I start doing a commercial for my favorite tool I'll try to give some sort of definition of what it does:
Reporting and analysis through graphical interface, presenting user with meaningful labeled objects, ensuring that user can create his own reports without specific knowledge of underlying data-structure or SQL with decent security set up to restrict data-access if needed.
Well, that was a definition "on the fly", but may give you some idea.
Biggest drawback of such nice tools is the initial cost of licenses........... T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question