Monday, 23 May 2011

SYNONYM small Concept but provide Best Security..

CREATE TABLE SYNONYM_Temp

(
id INT IDENTITY(1, 1),
varName VARCHAR(50)
)

CREATE SYNONYM Bank FOR SYNONYM_Temp

--Step :1

INSERT INTO Bank(varName)VALUES ('ICIC')

INSERT INTO Bank(varName)VALUES ('HSBC')

INSERT INTO Bank(varName)VALUES ('HDFC')

INSERT INTO Bank(varName)VALUES ('CITY')

SELECT *  FROM Bank-->SYNONYM
SELECT *  FROM SYNONYM_Temp-->Origional Table

--Step :2

DELETE FROM Bank WHERE ID= 4

SELECT * FROM Bank

---Step :3

UPDATE Bank SET varName= 'CITY' WHERE ID= 3

SELECT * FROM Bank

---Step :4, you can not change the Structure of Table

ALTER TABLE bank ADD Col3 VARCHAR(50)
 
DROP SYNONYM Bank
 
Note: using SYNONYM Client never know what is origional table Name.

1 comment: