<div>
cool - do you have more specific info on how to create a view in DB2? &nbsp;Is a view like a table, so that I could do queries on the view's columns?
</div>


cool - do you have more specific info on how to create a view in DB2?  Is a view like a table, so that I could do queries on the view's columns?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am asking a question on behalf of a friend. &nbsp;I don't have any experience with IBM DB2, but the question is this: &nbsp;Can we add a user that only has rights to view the data in specific columns on specific tables? &nbsp;If yes, can you maybe provide a screenshot or two to show how it's done or at least a vivid enough explanation of how to do it, since I'm working blind to give my friend his answer?<br />
<br />
Thanks!<br />
Mike
</div>
</div>


Hi Experts,

I am asking a question on behalf of a friend.  I don't have any experience with IBM DB2, but the question is this:  Can we add a user that only has rights to view the data in specific columns on specific tables?  If yes, can you maybe provide a screenshot or two to show how it's done or at least a vivid enough explanation of how to do it, since I'm working blind to give my friend his answer?

Thanks!
Mike

ibm db2 column access restrictions

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.