473,387 Members | 3,801 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Hide Data of column in Ms Sql server 2012

I want to dispaly password column data in format "***" .
How to do this security in sqlserver 2012
Sep 23 '15 #1
3 1812
Rabbit
12,516 Expert Mod 8TB
I don't believe that's something you can do. Instead, just set up the security so that only those that are allowed to see it can see it. Also, I hope you're not storing the passwords as plain text. That is very insecure and very bad practice. You should store them as hashes.
Sep 23 '15 #2
ck9663
2,878 Expert 2GB
AKA encrypted.

+1 on what Rabbit suggested.

~CK
Sep 23 '15 #3
madankarmukta
308 256MB
Agreed to the Suggestions above.

Apart from this ,Collate clause can also be used.
Sep 25 '15 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Das | last post by:
Hi everyone, I'm using datagrid control to display the data. I want to hide column to be displayed into the data grid. I'm using the code as given below: Method given below is used to bind the...
2
by: Thanh Nu | last post by:
Hi, I would like to hide a column in a web datagrid (with create columns automatically at runtime checked), and I cannot refer to the columns collection like this: DataGrid1.Columns(0).Visible...
4
by: Sidney | last post by:
Hi~ I want to know if I want to hide a column in datagrid because I don't want to show that column of data. How can I do this? Sidney
3
by: Jason | last post by:
How do I hide a column in a GridView in ASP.NET 2.0 when all of the columns are autogenerated based on the datasource? I want to hide the first of three columns, but the following doesn't work: ...
9
by: ghostwolf | last post by:
Hi, I want to hide a column in the asp:GridView, say one of the column of asp:BoundField. But it is not allowed to put <divinside for setting it display:none. What can I do? Thanks in millions.
4
by: Luqman | last post by:
I have populated the Child Accounts and Parent Accounts in a Grid View Control, I want to hide the Select Column of Parent Accounts, but not the Child Accounts, is it possible ? I am using VS...
0
by: =?ISO-8859-1?Q?=22Fernando_A=2E_G=F3mez_F=2E=22?= | last post by:
Hello all, I have an ASP.NET page with a GridView bounded to a DataSource. When I click the edit button/link, I'm able to update the data with no problemos. However, if further in my code I hide...
2
by: nikhilnangia1 | last post by:
How do you Hide a Column of data in a Data Grid in Access 2007 using VBA code? Please help me. This is urgent
14
by: MickT | last post by:
I've closed all SQL Server service except the MSSQLSERVER, and have set that service to startup in single user mode by using the -m switch in the Configuration Window. However, when I tried to...
0
by: cchavero | last post by:
I'm migrating my server from Windows Server 2008 to Windows Server 2012 R2, and when I execute some queries show me this error SQL0104, but in Windows Server 2008 execute correctly. My conecction is...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.