encrypted view

  • Thread starter Thread starter Som Nath Shukla
  • Start date Start date
S

Som Nath Shukla

create table hi
( Fname varchar(10)
lname varchar(10)
)

create view employee_V
AS
select EncryptByPassPhrase('aa',Lname) Lname, Fname from Hi

select * from employee_V

insert into employee_V values
('som','nath')

Hi I have table containing two ccloumn. due to security reason i have
created a view in encrypted form. Now i want to insert into table through
view but it show error.
Update or insert of view or function 'employee_V' failed because it contains
a derived or constant field.


plz help me asap.
 
This is not a C# question, so I'm going to say two things:
a: an "instead of" trigger
b: microsoft.public.sqlserver.*

Marc
 
Back
Top