[dbo].[View_Act

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:13 AM Wednesday, March 07, 2007
Last Modified	9:09:08 PM Friday, December 05, 2008

Property

Value

ANSI Nulls On

Quoted Identifier On

Created

11:10:13 AM Wednesday, March 07, 2007

Last Modified

9:09:08 PM Friday, December 05, 2008

Name
id
persid
call_req_id
last_mod_dt
time_spent
time_stamp
system_time
analyst
description
action_desc
type
knowledge_session
knowledge_tool
internal
tenant
activity_type
analyst_lastname
analyst_firstname
analyst_middlename

Name

persid

call_req_id

last_mod_dt

time_spent

time_stamp

system_time

analyst

description

action_desc

type

knowledge_session

knowledge_tool

internal

tenant

activity_type

analyst_lastname

analyst_firstname

analyst_middlename

Type	Action	Owning Principal
Grant	Select	service_desk_admin_group
Grant	Select	service_desk_ro_group

Type

Action

Owning Principal

Grant

Select

service_desk_admin_group

Grant

Select

service_desk_ro_group

SQL Script

CREATE view  View_Act_Log AS SELECT act_log.*, act_type.sym activity_type, View_Contact_Full.last_name analyst_lastname, View_Contact_Full.first_name analyst_firstname, View_Contact_Full.middle_name analyst_middlename FROM ((  act_log inner join  act_type ON act_log.type = act_type.code) left join  View_Contact_Full ON act_log.analyst = View_Contact_Full.contact_uuid)
GO
GRANT SELECT ON  [dbo].[View_Act_Log] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Act_Log] TO [service_desk_ro_group]
GO