473,416 Members | 1,712 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,416 software developers and data experts.

How to make a protected password field

284 100+
I am using sql server 2000 personal edition.

I want to know how can we make a password field in the table , so if any ope open the talbe it will only see ********** (even the admin) .

Hope you understand what i mean.
May 31 '10 #1
7 7756
Delerna
1,134 Expert 1GB
As far as I am aware you cannot create a field in a table that does that.

Sql server provides logins under security for that sort of thing

With that login you can then control the level of access any user has to
any database object (tables,views,stored procs...)
in any database.

Not sure if personal edition has that though
May 31 '10 #2
muddasirmunir
284 100+
So , is there any way i can protect my whole sqlserver 2000 (Enterprise Manager) so no body can open it with out password , even the computer administrater to see my database and tables.
Jun 3 '10 #3
ck9663
2,878 Expert 2GB
Whoever the admin can see everything. Encrypt those fields that needs to be hidden.

Good Luck!!!

~~ CK
Jun 3 '10 #4
ThatThatGuy
449 Expert 256MB
@muddasirmunir
You can encrypt the password externally and store it
Jun 7 '10 #5
muddasirmunir
284 100+
@ThatThatGuy
Yes ,encrypt externally is a good option.

But i donot know how what utility is best for it , might be notepad and I also donot know how to write,read,encrypte and decrypte notepad. Any link to good tutorial about this topic?
Jun 8 '10 #6
ThatThatGuy
449 Expert 256MB
@muddasirmunir
http://www.codeproject.com/KB/cs/Cryptography.aspx

has a good article on encryption and decryption using C#
Jun 8 '10 #7
ck9663
2,878 Expert 2GB
Here, read this.

Good Luck!!!

~~ CK
Jun 8 '10 #8

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

Similar topics

7
by: Mike | last post by:
I've been trying for the past week to put a simple code together. I have done a LOT of searching, found scripts showing the functions I would like to use, however when I mix them it all goes wrong,...
4
by: ScooterMX | last post by:
I have a page that is simply a password field. Doesn't scroll, do anything other than accept a password, and has a submit button. How can I automatically place the cursor in this password field...
4
by: Homa | last post by:
Hi, I have a quick question. I have a webpage allow user to modify his/her information. When I generate the form, I want to pre-load the information to the TextBoxes. But for the password...
4
by: feng | last post by:
For a HTTP textbox with a Type of "password", the default behaiver is that the field will be cleared out when the page is posted back. This make sense in most of the cases. But in some situation,...
4
by: J Sahoo | last post by:
Hello, I have a registration page where I am collecting user information (username, password, last name, age, etc...). I made the password field as PASSWORD (field type from the textbox). If user...
3
by: Neil Zanella | last post by:
Hello, I am trying to execute ADO.NET INSERT statement where one of the fields is coming from a password HTML control. When I access the text with password.Value and print with Response.Write...
10
by: dana lees | last post by:
Hello, I am developing a C# asp.net application. I have a webform which contains 2 dropdowns and a textbox with type="password". On "SelectedIndexChanged" event of the first dropdown, there is...
6
by: James | last post by:
Have a textbox that's in Password mode on a user creation page. Have several dropdowns that cause a PostBack out of necessity on this page. I cannot separate them. When one of these dropdowns...
7
by: fiefie.niles | last post by:
In ASP.Net I would like to create a text box that is a Password Field. How do I do that ? When I use the Textbox Field (from Toolbox - Standard), I did not find anything there that can make it a...
2
by: newkhan | last post by:
Hi Experts, I am currently using c#.net to complete my project and my problem is that for authentication i have used a form containing login and password fields but there is a...
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
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
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.