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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

privilage

Status
Not open for further replies.

langlui

Technical User
Aug 16, 2005
3
US
what is the difference between
1) select privileges on the actual table
and
2. select privileges on RDBMS.TVM table.
 
well,

your question is not clear at all.

priviledges on RDBMS.TVM are the access permissions for this table.

there are general priviledges which allow access to the database like connect.
There is one group called 'public', and whatever public can do is what any user can do having an userid and password.

May be you try to put your question again ?

Juliane
 
Hmm languli,

Refrase your question.

Select privilege on RDBMS genarally alloted to public.
Means any user in the system can have select privilege on default system objects.


Select privilege on your private table means only privileged users can do select on the the private table.

Hope it helps.



aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2
 
Hmm languli,

If i understand your question correctly.

Select privilege on RDBMS genarally alloted to public.
Means any user in the system can have select privilege on default system objects.


Select privilege on your private table means only privileged users can do select on the the private table.

Hope it helps.



aixnag
IBM Certified Specialist - P-series AIX 5L Administration
IBM Certified Specialist - AIX V4 HACMP
IBM eServer Certified Specialist – p690 Technical Support
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for Unix, Linux, Windows and OS/2
 
Status
Not open for further replies.

Similar threads

Part and Inventory Search

Sponsor

Back
Top