DB2 grant permission steps

[Abhiram]

I have a db2 table on which I require select permissions.
Who can do it?(I think the DBA or table owner can do it).
Whether the database restart is required? What is the exact command
for granting slect on table 'X'?
Please mention exact steps (stop/start database, add permissions, etc)
Thanks

[Knut Stolze]

Abhiram <ab******@indiatimes.com> wrote:

I have a db2 table on which I require select permissions.
Who can do it?(I think the DBA or table owner can do it).
Have a look at the SYSCAT.TABAUTH catalog view. Every user or group that
has the privilege "grantable" can pass it on.

SELECT grantee
FROM syscat.tabauth
WHERE selectauth = 'G' AND
( tabschema, tabname ) = ( <your fully qualified table name> )
Whether the database restart is required?
No, it is not.
What is the exact command
for granting slect on table 'X'?

Have a look at the SQL Reference:

GRANT SELECT ON <tablename> TO <user-or-group>

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[P. Saint-Jacques]

Steps: Assume you are the DBA or the Table Owner
db2 connect to <dbname>
db2 grant select on table to [userid,group,public]
db2 connect reset

No stop/start instance or deactivate/activate db commands necessary.

Go to the Web and search for the DB2 UDB docs.
http://www.software.ibm.com/data/db2/library/
Both the COmmand Line Ref. and the SQL ref. will show you those commands.
HTH, Pierre.

Abhiram wrote:

I have a db2 table on which I require select permissions.
Who can do it?(I think the DBA or table owner can do it).
Whether the database restart is required? What is the exact command
for granting slect on table 'X'?
Please mention exact steps (stop/start database, add permissions, etc)
Thanks

--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.