Views [dbo].[View_Group]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:10 AM Wednesday, March 07, 2007
Last Modified9:09:09 PM Friday, December 05, 2008
Columns
Name
contact_uuid
middle_name
alias
last_name
first_name
pri_phone_number
alt_phone_number
fax_number
mobile_phone_number
pager_number
email_address
location_uuid
floor_location
pager_email_address
room_location
contact_type
inactive
creation_user
creation_date
last_update_user
last_update_date
version_number
department
comments
company_uuid
organization_uuid
admin_organization_uuid
alternate_identifier
job_title
job_function
mail_stop
cost_center
userid
supervisor_contact_uuid
exclude_registration
delete_time
inrdid
tenant
Permissions
TypeActionOwning Principal
GrantSelectservice_desk_admin_group
GrantSelectservice_desk_ro_group
SQL Script
CREATE VIEW View_Group AS SELECT ca_contact.* FROM  ca_contact WHERE ca_contact.contact_type = 2308
GO
GRANT SELECT ON  [dbo].[View_Group] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Group] TO [service_desk_ro_group]
GO
Uses
Used By