UPDATE permission denied on column ''columnname'' of object ''viewname'', database ''databasename'', owner ''dbo''.

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  November 7, 2005 at 10:41 am

  #166879

  I have a view based on a single table, but not including all of the columns from the table.

  A user (SQL login) is denied access to the table, but has full permissions on the view. When the user tries to perform an UPDATE on the view they get messages of the form:

  UPDATE permission denied on column 'columnname' of object 'viewname', database 'databasename', owner 'dbo'.

  The columns listed in the error messages are in the view definition, and the user does have UPDATE permission on them.

  The puzzling thing is that if I create several connections to the database through Query Analyser, logged in as the problem user each time, and run the same UPDATE, I get 'UPDATE permission denied' messages listing different columns for each connection. And for some connections the UPDATE goes through without error.

  The database is in SQL Server 2000.

  Any ideas what is causing this? And how to clear things up?

• November 10, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  November 15, 2005 at 4:15 am

  #603852

  A little bit more information if it helps.

  The view definition lists the columns in no particular order. If I list the columns in alphabetic order then no 'UPDATE PERMISSION DENIED' errors occur. Still puzzling.

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  November 15, 2005 at 5:23 am

  #603865

  Please post the DDL for the table and view. Name the login being used for the update. Provide the output from sp_helprotect on both objects.

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  November 16, 2005 at 5:24 am

  #604151

  Login being used is 'jon', who is a member of just the 'SysGroup' and 'Team Name Users Group' roles.

  DDL for user, roles, table and view :

  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Team_Current_Employees]') and OBJECTPROPERTY(id, N'IsView') = 1)

  drop view [dbo].[Team_Current_Employees]

  GO

  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Personnel_Records]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  drop table [dbo].[Personnel_Records]

  GO

  if not exists (select * from dbo.sysusers where name = N'jon' and uid < 16382)

   EXEC sp_grantdbaccess N'jon', N'jon'

  GO

  if not exists (select * from dbo.sysusers where name = N'SysGroup' and uid > 16399)

   EXEC sp_addrole N'SysGroup'

  GO

  if not exists (select * from dbo.sysusers where name = N'Team Name Users Group' and uid > 16399)

   EXEC sp_addrole N'Team Name Users Group'

  GO

  exec sp_addrolemember N'SysGroup', N'jon'

  GO

  exec sp_addrolemember N'Team Name Users Group', N'jon'

  GO

  CREATE TABLE [dbo].[Personnel_Records] (

   [Actual_Appraisal_Date] [datetime] NULL ,

   [Actual_SCP] [numeric](3, 0) NULL ,

   [Address_1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Address_2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Address_3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Advertisement_Date] [datetime] NULL ,

   [Age] [int] NULL ,

   [Age_Band] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Name_of_Appointing_Manager] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Overhead_Rate_Paid_Frequency] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Postcode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Rate_Paid_Frequency] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Agency_Staff] [bit] NULL ,

   [Agency_Total_Hourly_Rate_Cost] [numeric](6, 2) NULL ,

   [Agency_Town] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Allow_Trade_Union_Disclosure] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Allowance_Bank_Holiday_Amount] [numeric](6, 2) NULL ,

   [Allowance_Bank_Holiday_working] [bit] NULL ,

   [Allowance_Conditioned_Night_duty] [bit] NULL ,

   [Allowance_Conditioned_Night_duty_Amount] [numeric](6, 2) NULL ,

   [Allowance_Conditioned_Overtime] [bit] NULL ,

   [Allowance_Conditioned_Overtime_Amount] [numeric](6, 2) NULL ,

   [Allowance_Irregular_hours] [bit] NULL ,

   [Allowance_Irregular_hours_Amount] [numeric](6, 2) NULL ,

   [Allowance_Leased_Car] [bit] NULL ,

   [Allowance_Leased_Car_Amount] [numeric](6, 2) NULL ,

   [Allowance_Night_duty] [bit] NULL ,

   [Allowance_Night_Duty_Amount] [numeric](6, 2) NULL ,

   [Allowance_Other_allowance] [bit] NULL ,

   [Allowance_Other_Allowance_Amount] [numeric](6, 2) NULL ,

   [Allowance_Other_details] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Allowance_Overtime] [bit] NULL ,

   [Allowance_Overtime_Amount] [numeric](6, 2) NULL ,

   [Allowance_PRP_Bonus] [bit] NULL ,

   [Allowance_PRP_Bonus_Amount] [numeric](6, 2) NULL ,

   [Allowance_Qualification] [bit] NULL ,

   [Allowance_Qualification_Amount] [numeric](6, 2) NULL ,

   [Allowance_Rota_Hours] [bit] NULL ,

   [Allowance_Rota_Hours_Amount] [numeric](6, 2) NULL ,

   [Allowance_Saturday_working] [bit] NULL ,

   [Allowance_Saturday_working_Amount] [numeric](6, 2) NULL ,

   [Allowance_Scarcity_Payment] [bit] NULL ,

   [Allowance_Scarcity_Payment_Amount] [numeric](6, 2) NULL ,

   [Allowance_Shift_Pay] [bit] NULL ,

   [Allowance_Shift_Pay_Amount] [numeric](6, 2) NULL ,

   [Allowance_Sleeping_in_duty] [bit] NULL ,

   [Allowance_Sleeping_in_Duty_Amount] [numeric](6, 2) NULL ,

   [Allowance_Sleeping_in_pay] [bit] NULL ,

   [Allowance_Sleeping_in_Pay_amount] [numeric](6, 2) NULL ,

   [Allowance_Sunday_working] [bit] NULL ,

   [Allowance_Sunday_working_Amount] [numeric](6, 2) NULL ,

   [Allowance_Temporary_Night_duty] [bit] NULL ,

   [Allowance_Temporary_Night_Duty_Amount] [numeric](6, 2) NULL ,

   [Allowance_Unsocial_hours_allowance] [bit] NULL ,

   [Allowance_Unsocial_hours_Amount] [numeric](6, 2) NULL ,

   [Allowance_Weekend_working] [bit] NULL ,

   [Allowance_Weekend_working_Amount] [numeric](6, 2) NULL ,

   [Annual_Earnings] [numeric](9, 2) NULL ,

   [Annual_Rate] [numeric](8, 2) NULL ,

   [Annual_Ticket_Loan] [bit] NULL ,

   [Application_Notes] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Appraisal_Completed] [bit] NULL ,

   [Appraiser] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [AVCs_Paid] [bit] NULL ,

   [B_Service_Months] [numeric](2, 0) NULL ,

   [B_Service_Years] [numeric](3, 0) NULL ,

   [Bank_Account_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Bank_Account_No] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Bank_Branch] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Bank_Name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Bank_Sort_Code] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Bodies_Notified_DFES] [bit] NULL ,

   [Bodies_Notified_DH] [bit] NULL ,

   [BS_Roll_No] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Can_more_be_done_to_enhance_equalities] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Car_Loan] [bit] NULL ,

   [Car_Registration_Number] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Casual_Worker] [bit] NULL ,

   [Charting] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_1_Adopted] [bit] NULL ,

   [Child_1_Adoption_Date] [datetime] NULL ,

   [Child_1_Age] [int] NULL ,

   [Child_1_Balance] [numeric](3, 1) NULL ,

   [Child_1_Date_of_Birth] [datetime] NULL ,

   [Child_1_Disabled] [bit] NULL ,

   [Child_1_Entitlement] [numeric](3, 1) NULL ,

   [Child_1_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_1_Previously_Taken] [numeric](3, 1) NULL ,

   [Child_1_Taken] [numeric](3, 1) NULL ,

   [Child_2_Adopted] [bit] NULL ,

   [Child_2_Adoption_Date] [datetime] NULL ,

   [Child_2_Age] [int] NULL ,

   [Child_2_Balance] [numeric](3, 1) NULL ,

   [Child_2_Date_of_Birth] [datetime] NULL ,

   [Child_2_Disabled] [bit] NULL ,

   [Child_2_Entitlement] [numeric](3, 1) NULL ,

   [Child_2_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_2_Previously_Taken] [numeric](3, 1) NULL ,

   [Child_2_Taken] [numeric](3, 1) NULL ,

   [Child_3_Adopted] [bit] NULL ,

   [Child_3_Adoption_Date] [datetime] NULL ,

   [Child_3_Age] [int] NULL ,

   [Child_3_Balance] [numeric](3, 1) NULL ,

   [Child_3_Date_of_Birth] [datetime] NULL ,

   [Child_3_Disabled] [bit] NULL ,

   [Child_3_Entitlement] [numeric](3, 1) NULL ,

   [Child_3_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_3_Previously_Taken] [numeric](3, 1) NULL ,

   [Child_3_Taken] [numeric](3, 1) NULL ,

   [Child_4_Adopted] [bit] NULL ,

   [Child_4_Adoption_Date] [datetime] NULL ,

   [Child_4_Age] [int] NULL ,

   [Child_4_Balance] [numeric](3, 1) NULL ,

   [Child_4_Date_of_Birth] [datetime] NULL ,

   [Child_4_Disabled] [bit] NULL ,

   [Child_4_Entitlement] [numeric](3, 1) NULL ,

   [Child_4_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_4_Previously_Taken] [numeric](3, 1) NULL ,

   [Child_4_Taken] [numeric](3, 1) NULL ,

   [Child_5_Adopted] [bit] NULL ,

   [Child_5_Adoption_Date] [datetime] NULL ,

   [Child_5_Age] [int] NULL ,

   [Child_5_Balance] [numeric](3, 1) NULL ,

   [Child_5_Date_of_Birth] [datetime] NULL ,

   [Child_5_Disabled] [bit] NULL ,

   [Child_5_Entitlement] [numeric](3, 1) NULL ,

   [Child_5_Name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Child_5_Previously_Taken] [numeric](3, 1) NULL ,

   [Child_5_Taken] [numeric](3, 1) NULL ,

   [Comments_from_experience_with_B_Council] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Comments_on_appraisal_effectiveness] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Comments_on_objectives_link] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Comments_on_questionnaire] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Communication_and_consultation_process_council_wide] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Communications_and_consultations_process_for_service_area] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Communications_and_consultations_process_for_unit] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Conditions_of_Employment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Contact_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Contact_Tel_No] [numeric](15, 0) NULL ,

   [Contact_Tel_No1] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Contract_Hours] [numeric](5, 2) NULL ,

   [Contract_Issue_Date] [datetime] NULL ,

   [Contract_Term] [varchar] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Contract_Term_Date] [datetime] NULL ,

   [Contract_Type] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Contract_Type_Date] [datetime] NULL ,

   [Corporate_Induction_Date] [datetime] NULL ,

   [Corporate_Induction_YN] [bit] NULL ,

   [Cost_Centre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Cost_Centre_Date] [datetime] NULL ,

   [Cost_Centre_Description] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Cost_Centre_Description_Date] [datetime] NULL ,

   [Cost_Code] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Council_Member] [bit] NULL ,

   [County] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Check_Clear] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Check_Done] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Check_Received] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Check_Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Check_Required] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Date_Check_Applied_For] [datetime] NULL ,

   [CRB_Date_of_next_check] [datetime] NULL ,

   [CRB_If_No_Confirmation_of_Suitability_Date] [datetime] NULL ,

   [CRB_Issue_Date] [datetime] NULL ,

   [CRB_Level] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_name_of_person_authorising] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Overseas_Police_Check_Recvd] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Overseas_Police_Check_Recvd_Date] [datetime] NULL ,

   [CRB_post_title_of_person_authorising] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Reason_for_employment_before_check] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [CRB_Renewal_Date_for_Overseas_Police_Check] [datetime] NULL ,

   [Current_Allowance_Total] [numeric](8, 2) NULL ,

   [Current_Benefit_Total] [numeric](8, 2) NULL ,

   [Current_Deduction_Total] [numeric](8, 2) NULL ,

   [Current_Employee] [bit] NULL ,

   [Current_Salary] [numeric](9, 2) NULL ,

   [Current_Salary_Date] [datetime] NULL ,

   [Current_SCP] [numeric](10, 0) NULL ,

   [Current_SCP_Date] [datetime] NULL ,

   [Date_Appraisal_Completed] [datetime] NULL ,

   [Date_Bodies_Notified_DFES] [datetime] NULL ,

   [Date_Bodies_Notified_DH] [datetime] NULL ,

   [Date_filled_in] [datetime] NULL ,

   [Date_of_Birth] [datetime] NULL ,

   [Date_Personal_Development_Plan_Received] [datetime] NULL ,

   [Deceased] [bit] NULL ,

   [Declaration_of_Interests] [bit] NULL ,

   [Declaration_of_Interests_Date] [datetime] NULL ,

   [Department_Code] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Department_Code_Date] [datetime] NULL ,

   [Departmental_Induction] [bit] NULL ,

   [Departmental_Induction_Date] [datetime] NULL ,

   [Dietary_Requirements] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Director] [bit] NULL ,

   [Disabled] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Division_Date] [datetime] NULL ,

   [EMail_Home] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [EMail_Work] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Eqqual_opps_implementation_for_race] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Eqqual_opps_implementation_for_sexuality] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Equal_opps_implementation_for_age] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Equal_opps_implementation_for_disability] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Equal_opps_implementation_for_gender] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Ethnic_Origin] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Ethnic_Origin_Census_Codes] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Ex_Directory] [bit] NULL ,

   [Exit_Interview_Completed] [bit] NULL ,

   [Expanded_Reasons_for_Leaving] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Fax] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Filled_in_by] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Fire_Warden] [bit] NULL ,

   [Fire_Warden_Certificate_Date] [datetime] NULL ,

   [Fire_Warden_Expiry_Date] [datetime] NULL ,

   [First_Aid_Certificate_Date] [datetime] NULL ,

   [First_Aid_Expiry_Date] [datetime] NULL ,

   [First_Aider] [bit] NULL ,

   [Flexi_time] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Forenames] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Frequency_of_Appraisals] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Full_Time_Equivalent] [numeric](5, 2) NULL ,

   [Generic_Grade] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Grade] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Grade_Band] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Grade_Date] [datetime] NULL ,

   [Holiday_Balance] [numeric](6, 2) NULL ,

   [Holiday_Balance_In_Hours] [numeric](6, 2) NULL ,

   [Holiday_Bfwd_0405] [numeric](6, 2) NULL ,

   [Holiday_Bfwd_0405_in_hrs] [numeric](6, 2) NULL ,

   [Holiday_Brought_Forward] [numeric](6, 2) NULL ,

   [Holiday_Brought_Forward_in_Hours] [numeric](6, 2) NULL ,

   [Holiday_Entitlement] [numeric](6, 2) NULL ,

   [Holiday_Entitlement_in_Hours] [numeric](6, 2) NULL ,

   [Holiday_Taken] [numeric](6, 2) NULL ,

   [Holiday_taken_in_advance] [numeric](3, 2) NULL ,

   [Holiday_taken_in_advance_in_hours] [numeric](6, 2) NULL ,

   [Holiday_Taken_In_Hrs] [numeric](6, 2) NULL ,

   [Hourly_Rate] [numeric](7, 4) NULL ,

   [How_effective_was_the_appraisal_process] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [HR_Pro_Contact] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [ID] [int] IDENTITY (1, 1) NOT NULL ,

   [Increment_Date] [datetime] NULL ,

   [Independent_Consultant] [bit] NULL ,

   [Induction_checklist_completed] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Initials] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Internal_Phone] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Intranet_Line_Manager_Login] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Intranet_Self_Service_Login] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [JEM_Job_Number] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Job_Share_Employee_No] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Job_Share_Name] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Known_As] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Last_Updated_By] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Last_Updated_On] [datetime] NULL ,

   [Least_rewarding_thing_about_working_for_B_Council] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Leaving_Bodies_Notified_Date_DFES] [datetime] NULL ,

   [Leaving_Bodies_Notified_Date_DH] [datetime] NULL ,

   [Leaving_Bodies_Notified_DFES] [bit] NULL ,

   [Leaving_Bodies_Notified_DH] [bit] NULL ,

   [Leaving_Date] [datetime] NULL ,

   [Leaving_Reason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Leaving_Registration_Bodies_Notified] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Leaving_Registration_Bodies_Notified_Date] [datetime] NULL ,

   [Leaving_to_Organisation] [varchar] (38) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Line_Manager] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Line_Manager_Induction_Date] [datetime] NULL ,

   [Line_Manager_Induction_YN] [bit] NULL ,

   [Location] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Location_full] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [LoginID] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [London_Weighting_Allowance] [numeric](9, 2) NULL ,

   [London_Weighting_Allowance_Date] [datetime] NULL ,

   [Main_Service_Area] [varchar] (28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Manager] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Marital_Status] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Max_SCP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Middle_Name] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Min_SCP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Mobile] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Monthly_Rate] [numeric](7, 2) NULL ,

   [Most_rewarding_thing_about_working_for_B_Council] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Nationality] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Nature_of_Disability] [varchar] (19) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [New_Employer] [varchar] (22) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Next_Appraisal_Due] [datetime] NULL ,

   [Next_Discipline_Expiry] [datetime] NULL ,

   [Next_Of_Kin] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Next_Of_Kin_Telephone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [NI_Code] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [NI_No] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Notes] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Notice_In] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Notice_Period] [int] NULL ,

   [One_Years_Service_Previous] [bit] NULL ,

   [Organisation_Level_Code] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Other_attractions_of_new_job] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Other_New_Employer] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Other_Reason_for_leaving] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Pay_Point_Number] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Payment_Frequency] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Payment_Method] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Payroll_Group] [numeric](6, 0) NULL ,

   [Payroll_Group_Number] [numeric](4, 0) NULL ,

   [Pension_Ees_Pct] [numeric](4, 2) NULL ,

   [Pension_Eligible] [datetime] NULL ,

   [Pension_Entry] [datetime] NULL ,

   [Pension_Ers_Pct] [numeric](4, 2) NULL ,

   [Pension_Scheme] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Pension_Scheme_Code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Person_Specification] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Personal_Development_Plan_Received] [bit] NULL ,

   [Photograph] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Place_of_Birth] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Post_Number] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Post_Title] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Post_Title_Date] [datetime] NULL ,

   [Postcode] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Previous_Name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Previous_Service_From] [datetime] NULL ,

   [Previous_Service_To] [datetime] NULL ,

   [Probation_End] [datetime] NULL ,

   [Probation_In] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Probation_Period] [int] NULL ,

   [Professional_Registration_Issue_Date] [datetime] NULL ,

   [Professional_Registration_Notes] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Professional_Registration_Number] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Professional_Registration_Renewal_Date] [datetime] NULL ,

   [Professional_Registration_Required] [bit] NULL ,

   [Proposed_Increase_Date] [datetime] NULL ,

   [Proposed_Salary] [numeric](8, 2) NULL ,

   [Proximity_Swipe_Card_No] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Reason_for_relationship_with_department] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Reason_for_relationship_with_team] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Reasons_for_relationship_with_manager] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Record_Number] [numeric](10, 0) NULL ,

   [Recruitment_Cost] [numeric](7, 2) NULL ,

   [Recruitment_Date] [datetime] NULL ,

   [Recruitment_Source] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Region] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Registered_Disabled_Number] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Relationship_with_Department] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Relationship_with_manager] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Relationship_with_team_or_section] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Retirement_Age] [int] NULL ,

   [Retirement_Date] [datetime] NULL ,

   [SA_Code] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Schools_Staff] [bit] NULL ,

   [Service_Area] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Service_Area_User] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Service_Months] [int] NULL ,

   [Service_Years] [int] NULL ,

   [Sex] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Shift] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Sickness_Taken] [numeric](6, 2) NULL ,

   [Sickness_Taken_12_months] [numeric](6, 2) NULL ,

   [Sickness_Taken_12_months_In_Hrs] [numeric](6, 2) NULL ,

   [Sickness_Taken_In_Hrs] [numeric](6, 2) NULL ,

   [Sickness_Taken_Last_Year] [numeric](6, 2) NULL ,

   [Sickness_Taken_Last_Year_In_Hrs] [numeric](6, 2) NULL ,

   [SSDS_Line_Number] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Staff_No] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Staff_Watchline_Number] [numeric](10, 0) NULL ,

   [Stakeholder_Pension] [bit] NULL ,

   [Standard_Hours] [numeric](5, 2) NULL ,

   [Standard_Hours_Date] [datetime] NULL ,

   [Start_Date_B] [datetime] NULL ,

   [Start_Date_Current_Position] [datetime] NULL ,

   [Start_Date_LG] [datetime] NULL ,

   [Structure] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Structure_Level_Admin] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Structure_Level_User] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Student] [bit] NULL ,

   [Supervise] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Surname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [T_Code] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Tax_Basis] [bit] NULL ,

   [Tax_Code] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Team_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Team_Name_User] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Team_Name1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Team_Name1_User] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Telephone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Temporary_Employee] [bit] NULL ,

   [Term_time_only] [bit] NULL ,

   [Title] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Total_Absence] [numeric](5, 1) NULL ,

   [Total_Absence_In_Hrs] [numeric](6, 2) NULL ,

   [Total_Outstanding_Loan_Balance] [numeric](8, 2) NULL ,

   [Town] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Trade_Union] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Training_and_Development_Opportunities_while_in_job] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Transfer_Date] [datetime] NULL ,

   [Type_of_Registration] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Type_of_Registration_Specify] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Type_of_Registration1] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Type_of_Registration2] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [U_Code] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Understanding_of_link_between_objectives_and_team_objectives] [bit] NULL ,

   [Unit_Date] [datetime] NULL ,

   [Unit_Section] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Unit_Section_User] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [View_User] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Weekly_Rate] [numeric](7, 2) NULL ,

   [What_attracted_you_to_the_new_job] [varchar] (29) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Work_Permit_Date] [datetime] NULL ,

   [Work_Permit_Expiry_Date] [datetime] NULL ,

   [Work_Permit_Received_YN] [bit] NULL ,

   [Work_Permit_Required] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [Working_Pattern] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [World_Faiths] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

   [TimeStamp] [timestamp] NULL

  ) ON [PRIMARY]

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_NULLS ON

  GO

  CREATE VIEW dbo.Team_Current_Employees

  AS

      SELECT Personnel_Records.CRB_Check_Reference, Personnel_Records.CRB_Check_Clear, Personnel_Records.CRB_Level, Personnel_Records.CRB_Check_Received, Personnel_Records.CRB_Overseas_Police_Check_Recvd, Personnel_Records.CRB_Reason_for_employment_before_check, Personnel_Records.CRB_name_of_person_authorising, Personnel_Records.CRB_post_title_of_person_authorising, Personnel_Records.Term_time_only, Personnel_Records.Actual_SCP, Personnel_Records.Team_Name1, Personnel_Records.Student, Personnel_Records.Contact_Name, Personnel_Records.Contact_Tel_No, Personnel_Records.Main_Service_Area, Personnel_Records.Induction_checklist_completed, Personnel_Records.Contact_Tel_No1, Personnel_Records.Holiday_Bfwd_0405, Personnel_Records.Holiday_Bfwd_0405_in_hrs, Personnel_Records.Job_Share_Name, Personnel_Records.Job_Share_Employee_No, Personnel_Records.Structure_Level_Admin, Personnel_Records.Structure_Level_User, Personnel_Records.Proximity_Swipe_Card_No, Personnel_Records.Holiday_Brought_Forward_in_Hours, Personnel_Records.Holiday_Entitlement_in_Hours, Personnel_Records.View_User, Personnel_Records.Service_Area_User, Personnel_Records.Unit_Section_User, Personnel_Records.Team_Name_User, Personnel_Records.Holiday_taken_in_advance_in_hours, Personnel_Records.Start_Date_Current_Position, Personnel_Records.Holiday_Balance_In_Hours, Personnel_Records.Holiday_Taken_In_Hrs, Personnel_Records.Sickness_Taken_In_Hrs, Personnel_Records.Sickness_Taken_Last_Year_In_Hrs, Personnel_Records.Total_Absence_In_Hrs, Personnel_Records.Work_Permit_Expiry_Date, Personnel_Records.Bodies_Notified_DFES, Personnel_Records.Professional_Registration_Required, Personnel_Records.Type_of_Registration, Personnel_Records.Type_of_Registration_Specify, Personnel_Records.Professional_Registration_Number, Personnel_Records.Professional_Registration_Issue_Date, Personnel_Records.Professional_Registration_Notes, Personnel_Records.Bodies_Notified_DH, Personnel_Records.Date_Bodies_Notified_DFES, Personnel_Records.Date_Bodies_Notified_DH, Personnel_Records.Professional_Registration_Renewal_Date, Personnel_Records.Type_of_Registration1, Personnel_Records.Type_of_Registration2, Personnel_Records.CRB_Overseas_Police_Check_Recvd_Date, Personnel_Records.Leaving_Bodies_Notified_Date_DH, Personnel_Records.Leaving_Bodies_Notified_DH, Personnel_Records.Leaving_Registration_Bodies_Notified_Date, Personnel_Records.Grade_Band, Personnel_Records.Age_Band, Personnel_Records.CRB_Check_Required, Personnel_Records.CRB_Date_Check_Applied_For, Personnel_Records.CRB_If_No_Confirmation_of_Suitability_Date, Personnel_Records.CRB_Renewal_Date_for_Overseas_Police_Check, Personnel_Records.Work_Permit_Required, Personnel_Records.Leaving_Bodies_Notified_DFES, Personnel_Records.Leaving_Bodies_Notified_Date_DFES, Personnel_Records.Leaving_Registration_Bodies_Notified, Personnel_Records.Supervise, Personnel_Records.Full_Time_Equivalent, Personnel_Records.Current_Employee, Personnel_Records.Structure, Personnel_Records.SA_Code, Personnel_Records.U_Code, Personnel_Records.T_Code, Personnel_Records.Departmental_Induction, Personnel_Records.Departmental_Induction_Date, Personnel_Records.Declaration_of_Interests, Personnel_Records.Declaration_of_Interests_Date, Personnel_Records.Sickness_Taken_12_months, Personnel_Records.Sickness_Taken_12_months_In_Hrs, Personnel_Records.Allow_Trade_Union_Disclosure, Personnel_Records.B_Service_Years, Personnel_Records.B_Service_Months, Personnel_Records.Child_2_Adopted, Personnel_Records.Child_5_Previously_Taken, Personnel_Records.Cost_Centre, Personnel_Records.County, Personnel_Records.CRB_Issue_Date, Personnel_Records.Current_SCP, Personnel_Records.Deceased, Personnel_Records.Annual_Earnings, Personnel_Records.Annual_Rate, Personnel_Records.Annual_Ticket_Loan, Personnel_Records.Application_Notes, Personnel_Records.Department_Code, Personnel_Records.Dietary_Requirements, Personnel_Records.Disabled, Personnel_Records.Unit_Section, Personnel_Records.Forenames, Personnel_Records.Frequency_of_Appraisals, Personnel_Records.Generic_Grade, Personnel_Records.Grade, Personnel_Records.Grade_Date, Personnel_Records.Holiday_Balance, Personnel_Records.Holiday_Brought_Forward, Personnel_Records.Holiday_Entitlement, Personnel_Records.Holiday_taken_in_advance, Personnel_Records.Team_Name1_User, Personnel_Records.HR_Pro_Contact, Personnel_Records.Holiday_Taken, Personnel_Records.Hourly_Rate, Personnel_Records.How_effective_was_the_appraisal_process, Personnel_Records.Increment_Date, Personnel_Records.Independent_Consultant, Personnel_Records.Initials, Personnel_Records.Internal_Phone, Personnel_Records.Division_Date, Personnel_Records.EMail_Home, Personnel_Records.EMail_Work, Personnel_Records.Eqqual_opps_implementation_for_race, Personnel_Records.Eqqual_opps_implementation_for_sexuality, Personnel_Records.Equal_opps_implementation_for_age, Personnel_Records.Equal_opps_implementation_for_disability, Personnel_Records.Equal_opps_implementation_for_gender, Personnel_Records.Ethnic_Origin, Personnel_Records.Ethnic_Origin_Census_Codes, Personnel_Records.Ex_Directory, Personnel_Records.Exit_Interview_Completed, Personnel_Records.Expanded_Reasons_for_Leaving, Personnel_Records.Director, Personnel_Records.Child_2_Adoption_Date, Personnel_Records.Child_2_Age, Personnel_Records.Child_2_Balance, Personnel_Records.Child_2_Date_of_Birth, Personnel_Records.Child_2_Disabled, Personnel_Records.Child_2_Entitlement, Personnel_Records.Child_2_Name, Personnel_Records.Child_2_Previously_Taken, Personnel_Records.Child_2_Taken, Personnel_Records.Department_Code_Date, Personnel_Records.Child_5_Taken, Personnel_Records.Comments_from_experience_with_B_Council, Personnel_Records.Comments_on_appraisal_effectiveness, Personnel_Records.Comments_on_objectives_link, Personnel_Records.Comments_on_questionnaire, Personnel_Records.Communication_and_consultation_process_council_wide, Personnel_Records.Appraisal_Completed, Personnel_Records.Appraiser, Personnel_Records.AVCs_Paid, Personnel_Records.Bank_Account_Name, Personnel_Records.Bank_Account_No, Personnel_Records.Bank_Branch, Personnel_Records.Bank_Name, Personnel_Records.Bank_Sort_Code, Personnel_Records.Start_Date_B, Personnel_Records.BS_Roll_No, Personnel_Records.Can_more_be_done_to_enhance_equalities, Personnel_Records.Car_Loan, Personnel_Records.Car_Registration_Number, Personnel_Records.Child_3_Adopted, Personnel_Records.Service_Area, Personnel_Records.Current_SCP_Date, Personnel_Records.Date_Appraisal_Completed, Personnel_Records.Date_filled_in, Personnel_Records.Date_of_Birth, Personnel_Records.Date_Personal_Development_Plan_Received, Personnel_Records.Child_3_Adoption_Date, Personnel_Records.Child_3_Age, Personnel_Records.Child_3_Balance, Personnel_Records.Child_3_Date_of_Birth, Personnel_Records.Child_3_Disabled, Personnel_Records.Child_3_Entitlement, Personnel_Records.Child_3_Name, Personnel_Records.Child_3_Previously_Taken, Personnel_Records.Child_3_Taken, Personnel_Records.Child_4_Adopted, Personnel_Records.Child_4_Adoption_Date, Personnel_Records.Payroll_Group, Personnel_Records.Payroll_Group_Number, Personnel_Records.Pension_Ees_Pct, Personnel_Records.Pension_Eligible, Personnel_Records.Pension_Entry, Personnel_Records.Pension_Ers_Pct, Personnel_Records.Pension_Scheme, Personnel_Records.Pension_Scheme_Code, Personnel_Records.Person_Specification, Personnel_Records.Personal_Development_Plan_Received, Personnel_Records.Photograph, Personnel_Records.Place_of_Birth, Personnel_Records.Post_Number, Personnel_Records.Post_Title, Personnel_Records.Post_Title_Date, Personnel_Records.Postcode, Personnel_Records.Previous_Name, Personnel_Records.Previous_Service_From, Personnel_Records.Casual_Worker, Personnel_Records.Actual_Appraisal_Date, Personnel_Records.Address_1, Personnel_Records.Address_2, Personnel_Records.Address_3, Personnel_Records.Advertisement_Date, Personnel_Records.Age, Personnel_Records.Communications_and_consultations_process_for_service_area, Personnel_Records.Fax, Personnel_Records.Filled_in_by, Personnel_Records.Fire_Warden, Personnel_Records.Fire_Warden_Certificate_Date, Personnel_Records.Fire_Warden_Expiry_Date, Personnel_Records.First_Aid_Certificate_Date, Personnel_Records.First_Aid_Expiry_Date, Personnel_Records.First_Aider, Personnel_Records.Location_full, Personnel_Records.LoginID, Personnel_Records.London_Weighting_Allowance, Personnel_Records.London_Weighting_Allowance_Date, Personnel_Records.Manager, Personnel_Records.Marital_Status, Personnel_Records.Max_SCP, Personnel_Records.Middle_Name, Personnel_Records.Min_SCP, Personnel_Records.Mobile, Personnel_Records.Monthly_Rate, Personnel_Records.Most_rewarding_thing_about_working_for_B_Council, Personnel_Records.Nationality, Personnel_Records.Nature_of_Disability, Personnel_Records.New_Employer, Personnel_Records.Next_Appraisal_Due, Personnel_Records.Intranet_Line_Manager_Login, Personnel_Records.Intranet_Self_Service_Login, Personnel_Records.JEM_Job_Number, Personnel_Records.Known_As, Personnel_Records.Last_Updated_By, Personnel_Records.Last_Updated_On, Personnel_Records.Least_rewarding_thing_about_working_for_B_Council, Personnel_Records.Leaving_Date, Personnel_Records.Leaving_Reason, Personnel_Records.Leaving_to_Organisation, Personnel_Records.Start_Date_LG, Personnel_Records.Line_Manager, Personnel_Records.Line_Manager_Induction_Date, Personnel_Records.Line_Manager_Induction_YN, Personnel_Records.Location, Personnel_Records.Current_Allowance_Total, Personnel_Records.Current_Benefit_Total, Personnel_Records.Current_Deduction_Total, Personnel_Records.Current_Salary, Personnel_Records.Current_Salary_Date, Personnel_Records.Previous_Service_To, Personnel_Records.Probation_End, Personnel_Records.Probation_In, Personnel_Records.Probation_Period, Personnel_Records.Proposed_Increase_Date, Personnel_Records.Proposed_Salary, Personnel_Records.Reason_for_relationship_with_department, Personnel_Records.Reason_for_relationship_with_team, Personnel_Records.Reasons_for_relationship_with_manager, Personnel_Records.Record_Number, Personnel_Records.Recruitment_Cost, Personnel_Records.Recruitment_Date, Personnel_Records.Recruitment_Source, Personnel_Records.Region, Personnel_Records.Registered_Disabled_Number, Personnel_Records.Relationship_with_Department, Personnel_Records.Relationship_with_manager, Personnel_Records.Relationship_with_team_or_section, Personnel_Records.Retirement_Age, Personnel_Records.Retirement_Date, Personnel_Records.Schools_Staff, Personnel_Records.Service_Months, Personnel_Records.Service_Years, Personnel_Records.Sex, Personnel_Records.Shift, Personnel_Records.Sickness_Taken, Personnel_Records.Sickness_Taken_Last_Year, Personnel_Records.SSDS_Line_Number, Personnel_Records.Staff_No, Personnel_Records.Staff_Watchline_Number, Personnel_Records.Stakeholder_Pension, Personnel_Records.Standard_Hours, Personnel_Records.Standard_Hours_Date, Personnel_Records.Surname, Personnel_Records.Tax_Basis, Personnel_Records.Tax_Code, Personnel_Records.Telephone, Personnel_Records.Temporary_Employee, Personnel_Records.Title, Personnel_Records.Total_Absence, Personnel_Records.Total_Outstanding_Loan_Balance, Personnel_Records.Town, Personnel_Records.Trade_Union, Personnel_Records.Training_and_Development_Opportunities_while_in_job, Personnel_Records.Transfer_Date, Personnel_Records.Understanding_of_link_between_objectives_and_team_objectives, Personnel_Records.Team_Name, Personnel_Records.Unit_Date, Personnel_Records.Weekly_Rate, Personnel_Records.What_attracted_you_to_the_new_job, Personnel_Records.Working_Pattern, Personnel_Records.Work_Permit_Date, Personnel_Records.Work_Permit_Received_YN, Personnel_Records.World_Faiths, Personnel_Records.Child_4_Age, Personnel_Records.Child_4_Balance, Personnel_Records.Child_4_Date_of_Birth, Personnel_Records.Child_4_Disabled, Personnel_Records.Child_4_Entitlement, Personnel_Records.Child_4_Name, Personnel_Records.Child_4_Previously_Taken, Personnel_Records.Child_4_Taken, Personnel_Records.Child_5_Adopted, Personnel_Records.Child_5_Adoption_Date, Personnel_Records.Child_5_Age, Personnel_Records.Child_5_Balance, Personnel_Records.Child_5_Date_of_Birth, Personnel_Records.Child_5_Disabled, Personnel_Records.Child_5_Entitlement, Personnel_Records.Next_Discipline_Expiry, Personnel_Records.Next_Of_Kin, Personnel_Records.Next_Of_Kin_Telephone, Personnel_Records.NI_Code, Personnel_Records.NI_No, Personnel_Records.Notes, Personnel_Records.Notice_In, Personnel_Records.Notice_Period, Personnel_Records.One_Years_Service_Previous, Personnel_Records.Organisation_Level_Code, Personnel_Records.Other_attractions_of_new_job, Personnel_Records.Other_New_Employer, Personnel_Records.Other_Reason_for_leaving, Personnel_Records.Pay_Point_Number, Personnel_Records.Payment_Frequency, Personnel_Records.Payment_Method, Personnel_Records.CRB_Check_Done, Personnel_Records.CRB_Date_of_next_check, Personnel_Records.Charting, Personnel_Records.Child_1_Adopted, Personnel_Records.Child_1_Adoption_Date, Personnel_Records.Child_1_Age, Personnel_Records.Child_1_Balance, Personnel_Records.Child_1_Date_of_Birth, Personnel_Records.Child_1_Disabled, Personnel_Records.Child_1_Entitlement, Personnel_Records.Child_1_Name, Personnel_Records.Child_1_Previously_Taken, Personnel_Records.Child_1_Taken, Personnel_Records.Child_5_Name, Personnel_Records.Cost_Centre_Date, Personnel_Records.Cost_Centre_Description, Personnel_Records.Cost_Centre_Description_Date, Personnel_Records.Cost_Code, Personnel_Records.Council_Member, Personnel_Records.Communications_and_consultations_process_for_unit, Personnel_Records.Conditions_of_Employment, Personnel_Records.Contract_Hours, Personnel_Records.Contract_Issue_Date, Personnel_Records.Contract_Term, Personnel_Records.Contract_Term_Date, Personnel_Records.Contract_Type, Personnel_Records.Contract_Type_Date, Personnel_Records.Corporate_Induction_Date, Personnel_Records.Corporate_Induction_YN, Personnel_Records.ID, Personnel_Records.TimeStamp

      FROM Personnel_Records

  GO

  SET QUOTED_IDENTIFIER OFF

  GO

  SET ANSI_NULLS ON

  GO

  Results of sp_helprotect for user, roles, table, view :

  exec sp_helprotect 'team_current_employees', 'jon'

  /* RESULTS

  Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346

  There are no matching rows on which to report.

  */

  exec sp_helprotect 'personnel_records', 'jon'

  /* RESULTS

  Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346

  There are no matching rows on which to report.

  */

  exec sp_helprotect 'team_current_employees', 'Team Name Users Group'

  /* RESULTS

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Delete,.

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Insert,.

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Update,Team_Name1

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Update,Service_Area_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Update,Unit_Section_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Deny      ,Update,Team_Name1_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Select,(All)

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Check_Reference

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Check_Clear

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Level

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Check_Received

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Overseas_Police_Check_Recvd

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Reason_for_employment_before_check

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_name_of_person_authorising

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_post_title_of_person_authorising

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Term_time_only

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Actual_SCP

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Student

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Contact_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Contact_Tel_No

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Main_Service_Area

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Induction_checklist_completed

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Contact_Tel_No1

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Bfwd_0405

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Bfwd_0405_in_hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Job_Share_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Job_Share_Employee_No

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Structure_Level_Admin

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Structure_Level_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Proximity_Swipe_Card_No

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Brought_Forward_in_Hours

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Entitlement_in_Hours

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,View_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Team_Name_User

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_taken_in_advance_in_hours

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Start_Date_Current_Position

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Balance_In_Hours

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Taken_In_Hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Sickness_Taken_In_Hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Sickness_Taken_Last_Year_In_Hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Total_Absence_In_Hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Work_Permit_Expiry_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bodies_Notified_DFES

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Professional_Registration_Required

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Type_of_Registration

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Type_of_Registration_Specify

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Professional_Registration_Number

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Professional_Registration_Issue_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Professional_Registration_Notes

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bodies_Notified_DH

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_Bodies_Notified_DFES

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_Bodies_Notified_DH

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Professional_Registration_Renewal_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Type_of_Registration1

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Type_of_Registration2

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Overseas_Police_Check_Recvd_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Bodies_Notified_Date_DH

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Bodies_Notified_DH

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Registration_Bodies_Notified_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Grade_Band

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Age_Band

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Check_Required

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Date_Check_Applied_For

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_If_No_Confirmation_of_Suitability_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Renewal_Date_for_Overseas_Police_Check

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Work_Permit_Required

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Bodies_Notified_DFES

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Bodies_Notified_Date_DFES

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Registration_Bodies_Notified

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Supervise

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Full_Time_Equivalent

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Employee

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Structure

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,SA_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,U_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,T_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Departmental_Induction

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Departmental_Induction_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Declaration_of_Interests

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Declaration_of_Interests_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Sickness_Taken_12_months

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Sickness_Taken_12_months_In_Hrs

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Allow_Trade_Union_Disclosure

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,B_Service_Years

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,B_Service_Months

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Adopted

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_5_Previously_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Cost_Centre

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,County

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,CRB_Issue_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_SCP

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Deceased

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Annual_Earnings

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Annual_Rate

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Annual_Ticket_Loan

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Application_Notes

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Department_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Dietary_Requirements

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Disabled

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Unit_Section

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Forenames

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Frequency_of_Appraisals

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Generic_Grade

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Grade

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Grade_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Balance

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Brought_Forward

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Entitlement

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_taken_in_advance

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,HR_Pro_Contact

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Holiday_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Hourly_Rate

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,How_effective_was_the_appraisal_process

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Increment_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Independent_Consultant

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Initials

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Internal_Phone

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Division_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,EMail_Home

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,EMail_Work

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Eqqual_opps_implementation_for_race

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Eqqual_opps_implementation_for_sexuality

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Equal_opps_implementation_for_age

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Equal_opps_implementation_for_disability

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Equal_opps_implementation_for_gender

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Ethnic_Origin

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Ethnic_Origin_Census_Codes

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Ex_Directory

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Exit_Interview_Completed

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Expanded_Reasons_for_Leaving

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Director

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Adoption_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Age

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Balance

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Date_of_Birth

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Disabled

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Entitlement

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Previously_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_2_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Department_Code_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_5_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Comments_from_experience_with_B_Council

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Comments_on_appraisal_effectiveness

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Comments_on_objectives_link

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Comments_on_questionnaire

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Communication_and_consultation_process_council_wide

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Appraisal_Completed

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Appraiser

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,AVCs_Paid

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bank_Account_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bank_Account_No

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bank_Branch

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bank_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Bank_Sort_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Start_Date_B

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,BS_Roll_No

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Can_more_be_done_to_enhance_equalities

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Car_Loan

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Car_Registration_Number

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Adopted

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Service_Area

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_SCP_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_Appraisal_Completed

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_filled_in

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_of_Birth

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Date_Personal_Development_Plan_Received

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Adoption_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Age

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Balance

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Date_of_Birth

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Disabled

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Entitlement

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Previously_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_3_Taken

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_4_Adopted

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Child_4_Adoption_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Payroll_Group

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Payroll_Group_Number

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Ees_Pct

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Eligible

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Entry

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Ers_Pct

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Scheme

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Pension_Scheme_Code

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Person_Specification

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Personal_Development_Plan_Received

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Photograph

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Place_of_Birth

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Post_Number

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Post_Title

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Post_Title_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Postcode

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Previous_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Previous_Service_From

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Casual_Worker

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Actual_Appraisal_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Address_1

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Address_2

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Address_3

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Advertisement_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Age

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Communications_and_consultations_process_for_service_area

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Fax

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Filled_in_by

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Fire_Warden

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Fire_Warden_Certificate_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Fire_Warden_Expiry_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,First_Aid_Certificate_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,First_Aid_Expiry_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,First_Aider

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Location_full

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,LoginID

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,London_Weighting_Allowance

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,London_Weighting_Allowance_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Manager

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Marital_Status

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Max_SCP

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Middle_Name

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Min_SCP

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Mobile

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Monthly_Rate

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Most_rewarding_thing_about_working_for_B_Council

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Nationality

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Nature_of_Disability

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,New_Employer

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Next_Appraisal_Due

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Intranet_Line_Manager_Login

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Intranet_Self_Service_Login

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,JEM_Job_Number

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Known_As

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Last_Updated_By

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Last_Updated_On

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Least_rewarding_thing_about_working_for_B_Council

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_Reason

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Leaving_to_Organisation

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Start_Date_LG

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Line_Manager

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Line_Manager_Induction_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Line_Manager_Induction_YN

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Location

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Allowance_Total

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Benefit_Total

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Deduction_Total

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Salary

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Current_Salary_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Previous_Service_To

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Probation_End

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Probation_In

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Probation_Period

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Proposed_Increase_Date

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Proposed_Salary

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Reason_for_relationship_with_department

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Reason_for_relationship_with_team

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Reasons_for_relationship_with_manager

  dbo,Team_Current_Employees,Team Name Users Group,dbo,Grant     ,Update,Record_Number

  */

  exec sp_helprotect 'personnel_records', 'Team Name Users Group'

  /* RESULTS

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Delete,.

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Insert,.

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,(New)

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Actual_Appraisal_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Actual_SCP

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Address_1

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Address_2

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Address_3

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Advertisement_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Age_Band

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Name_of_Appointing_Manager

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Overhead_Rate_Paid_Frequency

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Postcode

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Rate_Paid_Frequency

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Staff

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Total_Hourly_Rate_Cost

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Agency_Town

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allow_Trade_Union_Disclosure

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Bank_Holiday_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Bank_Holiday_working

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Conditioned_Night_duty

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Conditioned_Night_duty_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Conditioned_Overtime

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Conditioned_Overtime_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Irregular_hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Irregular_hours_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Leased_Car

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Leased_Car_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Night_duty

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Night_Duty_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Other_allowance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Other_Allowance_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Other_details

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Overtime

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Overtime_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_PRP_Bonus

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_PRP_Bonus_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Qualification

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Qualification_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Rota_Hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Rota_Hours_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Saturday_working

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Saturday_working_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Scarcity_Payment

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Scarcity_Payment_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Shift_Pay

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Shift_Pay_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sleeping_in_duty

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sleeping_in_Duty_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sleeping_in_pay

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sleeping_in_Pay_amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sunday_working

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Sunday_working_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Temporary_Night_duty

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Temporary_Night_Duty_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Unsocial_hours_allowance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Unsocial_hours_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Weekend_working

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Allowance_Weekend_working_Amount

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Annual_Earnings

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Annual_Rate

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Annual_Ticket_Loan

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Application_Notes

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Appraisal_Completed

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Appraiser

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,AVCs_Paid

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,B_Service_Months

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,B_Service_Years

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bank_Account_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bank_Account_No

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bank_Branch

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bank_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bank_Sort_Code

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bodies_Notified_DFES

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Bodies_Notified_DH

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,BS_Roll_No

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Can_more_be_done_to_enhance_equalities

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Car_Loan

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Car_Registration_Number

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Casual_Worker

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Charting

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Adopted

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Adoption_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Previously_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_1_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Adopted

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Adoption_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Previously_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_2_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Adopted

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Adoption_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Previously_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_3_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Adopted

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Adoption_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Previously_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_4_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Adopted

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Adoption_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Previously_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Child_5_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Comments_from_experience_with_B_Council

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Comments_on_appraisal_effectiveness

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Comments_on_objectives_link

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Comments_on_questionnaire

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Communication_and_consultation_process_council_wide

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Communications_and_consultations_process_for_service_area

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Communications_and_consultations_process_for_unit

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Conditions_of_Employment

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contact_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contact_Tel_No

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contact_Tel_No1

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Issue_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Term

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Term_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Type

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Contract_Type_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Corporate_Induction_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Corporate_Induction_YN

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Cost_Centre

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Cost_Centre_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Cost_Centre_Description

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Cost_Centre_Description_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Cost_Code

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Council_Member

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,County

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Check_Clear

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Check_Done

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Check_Received

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Check_Reference

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Check_Required

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Date_Check_Applied_For

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Date_of_next_check

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_If_No_Confirmation_of_Suitability_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Issue_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Level

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_name_of_person_authorising

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Overseas_Police_Check_Recvd

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Overseas_Police_Check_Recvd_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_post_title_of_person_authorising

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Reason_for_employment_before_check

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,CRB_Renewal_Date_for_Overseas_Police_Check

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Allowance_Total

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Benefit_Total

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Deduction_Total

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Employee

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Salary

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_Salary_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_SCP

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Current_SCP_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_Appraisal_Completed

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_Bodies_Notified_DFES

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_Bodies_Notified_DH

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_filled_in

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_of_Birth

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Date_Personal_Development_Plan_Received

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Deceased

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Declaration_of_Interests

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Declaration_of_Interests_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Department_Code

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Department_Code_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Departmental_Induction

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Departmental_Induction_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Dietary_Requirements

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Director

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Disabled

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Division_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,EMail_Home

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,EMail_Work

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Eqqual_opps_implementation_for_race

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Eqqual_opps_implementation_for_sexuality

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Equal_opps_implementation_for_age

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Equal_opps_implementation_for_disability

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Equal_opps_implementation_for_gender

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Ethnic_Origin

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Ethnic_Origin_Census_Codes

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Ex_Directory

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Exit_Interview_Completed

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Expanded_Reasons_for_Leaving

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Fax

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Filled_in_by

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Fire_Warden

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Fire_Warden_Certificate_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Fire_Warden_Expiry_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,First_Aid_Certificate_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,First_Aid_Expiry_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,First_Aider

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Flexi_time

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Forenames

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Frequency_of_Appraisals

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Full_Time_Equivalent

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Generic_Grade

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Grade

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Grade_Band

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Grade_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Balance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Balance_In_Hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Bfwd_0405

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Bfwd_0405_in_hrs

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Brought_Forward

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Brought_Forward_in_Hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Entitlement

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Entitlement_in_Hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Taken

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_taken_in_advance

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_taken_in_advance_in_hours

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Holiday_Taken_In_Hrs

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Hourly_Rate

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,How_effective_was_the_appraisal_process

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,HR_Pro_Contact

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Increment_Date

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Independent_Consultant

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Induction_checklist_completed

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Initials

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Internal_Phone

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Intranet_Line_Manager_Login

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Intranet_Self_Service_Login

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,JEM_Job_Number

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Job_Share_Employee_No

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Job_Share_Name

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Known_As

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Last_Updated_By

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Last_Updated_On

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Select,Least_rewarding_thing_about_working_for_B_Council

  dbo,Personnel_Records,Team Name Users Group,dbo,Deny      ,Update,(All+New)

  dbo,Personnel_Records,Team Name Users Group,dbo,Grant     ,Select,ID

  */

  exec sp_helprotect 'team_current_employees', 'SysGroup'

  /* RESULTS

  Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346

  There are no matching rows on which to report.

  */

  exec sp_helprotect 'personnel_records', 'SysGroup'

  /* RESULTS

  Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346

  There are no matching rows on which to report.

  */

  Modifying the view definition so that the columns list is in alphabetic order seems to cure the error, but I'd like to find a proper reason for this. Thanks for any assistance. This is really doing my head in.

   

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  November 16, 2005 at 9:32 am

  #604229

  Lastley could you provide the update statement that fails!

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  November 17, 2005 at 6:55 am

  #604398

  OK, a typical UPDATE that fails is:

  UPDATE Team_Current_Employees

  SET FORENAMES = '',

   SURNAME = '',

   UNIT_SECTION = '',

   CONTRACT_TYPE = '',

   PAY_POINT_NUMBER = '',

   INTERNAL_PHONE = '',

   CONTRACT_TERM = '',

   SERVICE_AREA = '',

   MANAGER = '',

   LOCATION_FULL = '',

   TEAM_NAME = '',

   STAFF_NO = '',

   LINE_MANAGER = '',

   MIDDLE_NAME = '',

   STANDARD_HOURS = 0,

   CONTRACT_HOURS = 0,

   POST_NUMBER = '',

   WORKING_PATTERN = '',

   SUPERVISE = '',

   POST_TITLE = '',

   KNOWN_AS = '',

   JOB_SHARE_NAME = '',

   START_DATE_LG = null,

   START_DATE_B = null,

   PROBATION_PERIOD = 0,

   PROBATION_IN = '',

   NOTICE_PERIOD = 0,

   NOTICE_IN = '',

   LINE_MANAGER_INDUCTION_YN = 0,

   CORPORATE_INDUCTION_YN = 0,

   CORPORATE_INDUCTION_DATE = null,

   LINE_MANAGER_INDUCTION_DATE = null,

   SSDS_LINE_NUMBER = '',

   ETHNIC_ORIGIN_CENSUS_CODES = '',

   LEAVING_REASON = '',

   LEAVING_TO_ORGANISATION = '',

   LEAVING_DATE = null,

   EXIT_INTERVIEW_COMPLETED = 0,

   BODIES_NOTIFIED_DFES = 0,

   BODIES_NOTIFIED_DH = 0,

   DATE_BODIES_NOTIFIED_DFES = null,

   DATE_BODIES_NOTIFIED_DH = null,

   START_DATE_CURRENT_POSITION = null,

   INDUCTION_CHECKLIST_COMPLETED = '',

   DEPARTMENTAL_INDUCTION = 0,

   DEPARTMENTAL_INDUCTION_DATE = null,

   DECLARATION_OF_INTERESTS = 0,

   DECLARATION_OF_INTERESTS_DATE = null,

   HOLIDAY_ENTITLEMENT_IN_HOURS = 0,

   HOLIDAY_BROUGHT_FORWARD_IN_HOURS = 0,

   HOLIDAY_ENTITLEMENT = 0,

   HOLIDAY_BROUGHT_FORWARD = 0,

   HOLIDAY_TAKEN_IN_ADVANCE = 0,

   HOLIDAY_TAKEN_IN_ADVANCE_IN_HOURS = 0,

   HOLIDAY_BFWD_0405 = 0,

   HOLIDAY_BFWD_0405_IN_HRS = 0,

   TITLE = '',

   PREVIOUS_NAME = '',

   DATE_OF_BIRTH = null,

   ADDRESS_1 = '',

   ADDRESS_2 = '',

   ADDRESS_3 = '',

   TOWN = '',

   POSTCODE = '',

   TELEPHONE = '',

   MOBILE = '',

   FAX = '',

   EMAIL_WORK = '',

   EMAIL_HOME = '',

   CAR_REGISTRATION_NUMBER = '',

   COUNTY = '',

   EX_DIRECTORY = 0,

   NEXT_OF_KIN = '',

   NEXT_OF_KIN_TELEPHONE = '',

   AGE = 0,

   DECEASED = 0,

   DISABLED = '',

   TRADE_UNION = '',

   NI_NO = '',

   ETHNIC_ORIGIN = '',

   ALLOW_TRADE_UNION_DISCLOSURE = '',

   SEX = '',

   CRB_ISSUE_DATE = null,

   CRB_CHECK_CLEAR = '',

   CRB_CHECK_REFERENCE = '',

   CRB_LEVEL = '',

   CRB_NAME_OF_PERSON_AUTHORISING = '',

   CRB_POST_TITLE_OF_PERSON_AUTHORISING = '',

   WORK_PERMIT_DATE = null,

   WORK_PERMIT_RECEIVED_YN = 0,

   CRB_CHECK_REQUIRED = '',

   CRB_DATE_CHECK_APPLIED_FOR = null,

   CRB_IF_NO_CONFIRMATION_OF_SUITABILITY_DATE = null,

   CRB_OVERSEAS_POLICE_CHECK_RECVD_DATE = null,

   PROFESSIONAL_REGISTRATION_REQUIRED = 0,

   TYPE_OF_REGISTRATION = '',

   TYPE_OF_REGISTRATION1 = '',

   TYPE_OF_REGISTRATION2 = '',

   PROFESSIONAL_REGISTRATION_NOTES = '',

   TYPE_OF_REGISTRATION_SPECIFY = '',

   PROFESSIONAL_REGISTRATION_NUMBER = '',

   PROFESSIONAL_REGISTRATION_ISSUE_DATE = null,

   CRB_REASON_FOR_EMPLOYMENT_BEFORE_CHECK = '',

   COST_CENTRE = '',

   COST_CENTRE_DESCRIPTION = '',

   CURRENT_SALARY = 0,

   LONDON_WEIGHTING_ALLOWANCE = 0,

   GRADE = '',

   PAYROLL_GROUP_NUMBER = 0,

   ACTUAL_SCP = 0,

   GRADE_BAND = '',

   FIRST_AIDER = 0,

   FIRST_AID_CERTIFICATE_DATE = null,

   JEM_JOB_NUMBER = '',

   ANNUAL_TICKET_LOAN = 0,

   CAR_LOAN = 0,

   FIRE_WARDEN = 0,

   FIRE_WARDEN_CERTIFICATE_DATE = null,

   FIRE_WARDEN_EXPIRY_DATE = null,

   DIETARY_REQUIREMENTS = '',

   TEAM_NAME_USER = '',

   VIEW_USER = '',

   LOGINID = '',

   DEPARTMENT_CODE = '',

   STRUCTURE_LEVEL_ADMIN = '',

   STRUCTURE_LEVEL_USER = '',

   PROXIMITY_SWIPE_CARD_NO = '',

   HR_PRO_CONTACT = '',

   INTRANET_SELF_SERVICE_LOGIN = '',

   NOTES = '',

   CURRENT_EMPLOYEE = 0

  WHERE id = 1

  Note that sometimes the update goes through fine, but more often than not I'd get the 'UPDATE permission denied' error. The list columns on which 'UPDATE permission is denied' varies, but a typical list is as follows :

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Middle_Name' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'LoginID' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Location_full' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Fire_Warden_Expiry_Date' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Fire_Warden_Certificate_Date' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Fax' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Post_Title' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Post_Number' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Server: Msg 230, Level 14, State 1, Line 1

  UPDATE permission denied on column 'Payroll_Group_Number' of object 'Team_Current_Employees', database 'mydb', owner 'dbo'.

  Thanks for your interest in this Kory.

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 17, 2005 at 1:04 pm

  #604514

  Johnny,  I noticed you are showing 'deny' permissions on some of the columns you are trying to update!!

  First you haven't posted the code that set those up

  Second if you have Deny on any of the columns the update affects it will fail!

  It does not makes any sense that the ordering of the columns fix the problem unless when you are 'ordering' them you are actually changing the permissions somehow

  Cheers,

   

  
  * Noel

• Johnny Doyle

  Right there with Babe

  Points: 745

  More actions

  November 18, 2005 at 5:30 am

  #604603

  The UPDATE permissions are denied on the Personnel_Records table. The required UPDATE permissions are granted to the user (via their membership of the 'Team Name Users Group' role) on the Team_Current_Employees view.

  Permissions are applied as follows. For the table:

  DENY UPDATE(Allowance_Irregular_hours_Amount,Child_3_Adopted,Communications_and_consultations_process_for_unit,Allowance_Leased_Car,Allowance_Leased_Car_Amount,Allowance_Night_duty,Allowance_Night_Duty_Amount,Allowance_Other_allowance,Allowance_Other_Allowance_Amount,Cost_Code,CRB_Date_of_next_check,Current_Allowance_Total,Current_Salary_Date,Declaration_of_Interests_Date,Department_Code,Department_Code_Date,Departmental_Induction,Departmental_Induction_Date,Dietary_Requirements,Director,Disabled,Division_Date,EMail_Home,EMail_Work,Eqqual_opps_implementation_for_race,Eqqual_opps_implementation_for_sexuality,Equal_opps_implementation_for_age,Equal_opps_implementation_for_disability,Equal_opps_implementation_for_gender,Ethnic_Origin,Ethnic_Origin_Census_Codes,Ex_Directory,Exit_Interview_Completed,Expanded_Reasons_for_Leaving,Fax,Filled_in_by,Fire_Warden,Fire_Warden_Certificate_Date,Relationship_with_manager,Relationship_with_team_or_section,Retirement_Age,Retirement_Date,SA_Code,Schools_Staff,Service_Area,

  Service_Area_User,Service_Months,Service_Years,Sex,Shift,Sickness_Taken,Sickness_Taken_12_months,Sickness_Taken_12_months_In_Hrs,Sickness_Taken_In_Hrs,Sickness_Taken_Last_Year,Sickness_Taken_Last_Year_In_Hrs,SSDS_Line_Number,Staff_No,Staff_Watchline_Number,Stakeholder_Pension,Standard_Hours,Standard_Hours_Date,Start_Date_B,Start_Date_Current_Position,Start_Date_LG,Structure,Structure_Level_Admin,Structure_Level_User,Student,Date_Bodies_Notified_DH,Holiday_Balance_In_Hours,Holiday_Bfwd_0405,Holiday_Bfwd_0405_in_hrs,Holiday_Brought_Forward,Holiday_Brought_Forward_in_Hours,Holiday_Entitlement,Holiday_Entitlement_in_Hours,Holiday_Taken,Holiday_taken_in_advance,Holiday_taken_in_advance_in_hours,Holiday_Taken_In_Hrs,Hourly_Rate,How_effective_was_the_appraisal_process,HR_Pro_Contact,Increment_Date,Independent_Consultant,Induction_checklist_completed,Initials,Internal_Phone,Intranet_Line_Manager_Login,Intranet_Self_Service_Login,JEM_Job_Number,Job_Share_Employee_No,Job_Share_Name,Known_As,Last_Updated_By,Last_Updated_On,

  Least_rewarding_thing_about_working_for_B_Council,Supervise,Surname,T_Code,Tax_Basis,Tax_Code,Team_Name,Team_Name_User,Team_Name1,Team_Name1_User,Telephone,Temporary_Employee,Term_time_only,Title,Total_Absence,Total_Absence_In_Hrs,Total_Outstanding_Loan_Balance,Town,Trade_Union,Training_and_Development_Opportunities_while_in_job,Transfer_Date,Type_of_Registration,Type_of_Registration_Specify,Type_of_Registration1,Type_of_Registration2,U_Code,Understanding_of_link_between_objectives_and_team_objectives,Unit_Date,Unit_Section,Unit_Section_User,View_User,Weekly_Rate,Leaving_Bodies_Notified_Date_DFES,Leaving_Bodies_Notified_Date_DH,Leaving_Bodies_Notified_DFES,Leaving_Bodies_Notified_DH,Leaving_Date,Leaving_Reason,Leaving_Registration_Bodies_Notified,Leaving_Registration_Bodies_Notified_Date,Leaving_to_Organisation,Line_Manager,Line_Manager_Induction_Date,Line_Manager_Induction_YN,Location,Location_full,LoginID,London_Weighting_Allowance,London_Weighting_Allowance_Date,Main_Service_Area,Manager,Marital_Status,

  Max_SCP,Middle_Name,Min_SCP,Mobile,Monthly_Rate,Most_rewarding_thing_about_working_for_B_Council,Nationality,Nature_of_Disability,New_Employer,Next_Appraisal_Due,Next_Discipline_Expiry,Next_Of_Kin,Next_Of_Kin_Telephone,NI_Code,NI_No,Notes,Notice_In,Notice_Period,One_Years_Service_Previous,Organisation_Level_Code,Other_attractions_of_new_job,Other_New_Employer,Other_Reason_for_leaving,Pay_Point_Number,Payment_Frequency,Payment_Method,Payroll_Group,Payroll_Group_Number,Pension_Ees_Pct,Pension_Eligible,Pension_Entry,Pension_Ers_Pct,Pension_Scheme,Pension_Scheme_Code,Person_Specification,Personal_Development_Plan_Received,Photograph,Child_2_Taken,CRB_If_No_Confirmation_of_Suitability_Date,CRB_Issue_Date,CRB_Level,CRB_name_of_person_authorising,CRB_Overseas_Police_Check_Recvd,Place_of_Birth,Post_Number,Post_Title,Post_Title_Date,Postcode,Previous_Name,Previous_Service_From,Previous_Service_To,Probation_End,Probation_In,Probation_Period,Professional_Registration_Issue_Date,Professional_Registration_Notes,

  Professional_Registration_Number,Professional_Registration_Renewal_Date,Professional_Registration_Required,Proposed_Increase_Date,Proposed_Salary,Proximity_Swipe_Card_No,Reason_for_relationship_with_department,Reason_for_relationship_with_team,Reasons_for_relationship_with_manager,Record_Number,Recruitment_Cost,Recruitment_Date,Recruitment_Source,Region,Registered_Disabled_Number,Relationship_with_Department,Fire_Warden_Expiry_Date,First_Aid_Certificate_Date,First_Aid_Expiry_Date,First_Aider,Flexi_time,Forenames,Frequency_of_Appraisals,Full_Time_Equivalent,Generic_Grade,Grade,Grade_Band,Grade_Date,Holiday_Balance,What_attracted_you_to_the_new_job,Work_Permit_Date,Work_Permit_Expiry_Date,Work_Permit_Received_YN,Work_Permit_Required,Working_Pattern,World_Faiths,Council_Member,County,Conditions_of_Employment,Contact_Name,Contact_Tel_No,Communications_and_consultations_process_for_service_area,Cost_Centre_Description_Date,CRB_Date_Check_Applied_For,CRB_Renewal_Date_for_Overseas_Police_Check,Current_Salary,

  Date_Bodies_Notified_DFES,Date_filled_in,Date_of_Birth,Date_Personal_Development_Plan_Received,Deceased,Declaration_of_Interests,Child_3_Adoption_Date,Child_3_Age,Allowance_Other_details,Allowance_Overtime,Allowance_Overtime_Amount,Allowance_PRP_Bonus,Allowance_PRP_Bonus_Amount,Allowance_Qualification,Allowance_Qualification_Amount,Allowance_Rota_Hours,Allowance_Rota_Hours_Amount,Allowance_Saturday_working,Actual_Appraisal_Date,Actual_SCP,Address_1,Address_2,Address_3,Advertisement_Date,Age,Age_Band,Agency_Name,Agency_Name_of_Appointing_Manager,Agency_Overhead_Rate_Paid_Frequency,Agency_Postcode,Agency_Rate_Paid_Frequency,Agency_Staff,Agency_Total_Hourly_Rate_Cost,Agency_Town,Allow_Trade_Union_Disclosure,Allowance_Bank_Holiday_Amount,Allowance_Bank_Holiday_working,Allowance_Conditioned_Night_duty,Allowance_Conditioned_Night_duty_Amount,Allowance_Conditioned_Overtime,Allowance_Conditioned_Overtime_Amount,Allowance_Irregular_hours,Allowance_Saturday_working_Amount,Allowance_Scarcity_Payment,Allowance_Scarcity_Payment_Amount,

  Allowance_Shift_Pay,Allowance_Shift_Pay_Amount,Allowance_Sleeping_in_duty,Allowance_Sleeping_in_Duty_Amount,Allowance_Sleeping_in_pay,Child_3_Balance,Contact_Tel_No1,CRB_Check_Clear,CRB_Check_Done,Contract_Hours,Contract_Issue_Date,Contract_Term,Child_3_Date_of_Birth,Child_3_Disabled,Child_3_Entitlement,Child_3_Name,Child_3_Previously_Taken,Child_3_Taken,Child_4_Adopted,Child_4_Adoption_Date,Child_4_Age,Child_4_Balance,Child_4_Date_of_Birth,Child_4_Disabled,CRB_Overseas_Police_Check_Recvd_Date,Current_Benefit_Total,Current_SCP,Allowance_Sleeping_in_Pay_amount,Allowance_Sunday_working,Allowance_Sunday_working_Amount,Allowance_Temporary_Night_duty,Allowance_Temporary_Night_Duty_Amount,Allowance_Unsocial_hours_allowance,Allowance_Unsocial_hours_Amount,Allowance_Weekend_working,Allowance_Weekend_working_Amount,Annual_Earnings,Child_4_Entitlement,Contract_Term_Date,CRB_Check_Received,Child_4_Name,Child_4_Previously_Taken,Child_4_Taken,Child_5_Adopted,Child_5_Adoption_Date,Child_5_Age,Child_5_Balance,Contract_Type,

  Contract_Type_Date,Corporate_Induction_Date,Corporate_Induction_YN,Annual_Rate,Child_5_Date_of_Birth,CRB_post_title_of_person_authorising,Current_Deduction_Total,Current_SCP_Date,Child_5_Disabled,Child_5_Entitlement,Child_5_Name,Child_5_Previously_Taken,Annual_Ticket_Loan,Application_Notes,Appraisal_Completed,Appraiser,AVCs_Paid,B_Service_Months,B_Service_Years,Bank_Account_Name,Bank_Account_No,Bank_Branch,Bank_Name,Bank_Sort_Code,Bodies_Notified_DFES,Bodies_Notified_DH,BS_Roll_No,Child_5_Taken,Cost_Centre,CRB_Check_Reference,CRB_Check_Required,Can_more_be_done_to_enhance_equalities,Car_Loan,Car_Registration_Number,Casual_Worker,Charting,Child_1_Adopted,Child_1_Adoption_Date,Child_1_Age,Child_1_Balance,Child_1_Date_of_Birth,Child_1_Disabled,Child_1_Entitlement,Child_1_Name,Child_1_Previously_Taken,Child_1_Taken,Child_2_Adopted,Child_2_Adoption_Date,Child_2_Age,Child_2_Balance,Child_2_Date_of_Birth,CRB_Reason_for_employment_before_check,Current_Employee,Date_Appraisal_Completed,Cost_Centre_Date,

  Cost_Centre_Description,Child_2_Disabled,Comments_from_experience_with_B_Council,Comments_on_appraisal_effectiveness,Comments_on_objectives_link,Comments_on_questionnaire,Communication_and_consultation_process_council_wide,Child_2_Entitlement,Child_2_Name,Child_2_Previously_Taken) ON Personnel_Records TO [Team Name Users Group]

  For the view, firstly:

  GRANT UPDATE ON Team_Current_Employees TO [Team Name Users Group]

  and then to deny UPDATE permission on a couple of columns (none of which are used in the UPDATE command that fails):

  DENY UPDATE(Team_Name1,Service_Area_User,Unit_Section_User,Team_Name1_User) ON Team_Current_Employees TO [Team Name Users Group]

  One thing I've noticed that puzzles me too, the sp_helprotect results for the Personnel_Records table does not list all of columns on which SELECT permissions is denied. Even if I execute...

  DENY SELECT(Middle_Name) ON Personnel_Records TO [Team Name Users Group]

  ... this column still fails to appear in the sp_helprotect results. Is this a known quirk of sp_helprotect, that only so many columns are listed, or is the underlying metadata dodgy?

  I know reordering the columns in the view definition should make no difference, but its the only way, by chance, that I've got the UPDATE to go through successfully every time. No permissions were reapplied manually, only what SQL must do automatically when a view definition is changed.