rheiser2002
Programmer
when applying security passwords to databases, can you restrict the user from certain columns in a table?
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!
database security
- Thread starter rheiser2002
- Start date
- Status
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
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
![[gorgeous]](/data/assets/smilies/gorgeous.gif "[gorgeous] [gorgeous]")
- Status
Similar threads
- Locked
- Question
- Locked
- Question