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

database security

Status
Not open for further replies.

rheiser2002

Programmer
Joined
Feb 11, 2003
Messages
2
Location
US
when applying security passwords to databases, can you restrict the user from certain columns in a table?
 
Hello rheiser2002,

This depends on the facility provided by the database. In general creating a VIEW is the best suited solution to your requirement.

Oracle supports views, synonyms.
Sybase & MS SQL Server allows access to limited field of a table to a user.

Manu
 
What database platform are you talking about?

Transcend
[gorgeous]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top