database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
ㆍMS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MS-SQL Q&A 1066 게시물 읽기
No. 1066
문제를 풀고 있는데요.......
작성자
초보학생
작성일
2003-11-28 12:25ⓒ
2003-11-28 12:38ⓜ
조회수
4,408

You are designing your company's SQL Server 2000 sales database, which will be accessed by a custom application. Customer service and marketing employees require SELECT, INSERT, and UPDATE permissions on all tables in the Sales database. In addition to using the custom application, the marketing employees will use Microsoft Excel to retrieve data from the sales database to create charts.
Customer service employees belong to a Microsoft Windows 2000 group named CSR, and marketing employees belong to a Windows 2000 group named Marketing.
You want the customer service employees to access the sales database only from within the custom application.

You want to allow the marketing employees to use both the custom application and Excel to access the sales database.

No permissions have been granted in the database.
What should you do?

 

A. Create a database role named Marketing for the marketing employees and a database role named CustomerService for the customer service employees.
Add the Windows 2000 groups to the user-defined database roles.
Grant SELECT permissions on all tables in the database to the Marketing database role.
Grant SELECT, INSERT, and UPDATE permissions on all tables in the database to the
CustomerService database role.

 

 

B. Create one application role to be used by both the customer service and marketing employees.
Grant SELECT permissions on all tables in the database to the Windows 2000 Marketing group.
Grant SELECT, INSERT, and UPDATE permissions on all tables in the database to the Windows 2000 CSR group.

 

 

C. Create an application role for the custom application.
Grant SELECT, INSERT and UPDATE permissions to the application role. Create a database role named Marketing for the marketing employees.
Add the Windows 2000 Marketing group to the Marketing database role.
Grant SELECT permissions on all tables in the database to the Marketing database role.

 

D. Create one application role for the customer service employees.
Create a second application role for the marketing employees.
Grant SELECT permissions on all tables in the database to the application role to be used by the marketing employees.
Grant SELECT, INSERT, and UPDATE permissions on all tables in the database to the application role to be used by the customer service employees.

 

 

E. Create one application role for the customer service employees.
Create a second application role for the marketing employees to access the Sales database by using the custom application.
Create a third application role for the marketing employees to use when retrieving data from Excel.
Grant SELECT permissions on all tables in the database to both application roles to be used by the marketing employees.
Grant SELECT, INSERT, and UPDATE permissions on all tables in the database to the application role to be used by the customer service employees.

 

답은 C인데 컴퓨터 지식이 별로 없어서 잘 모르겠어요

문제도 해석도 정확히 안되고요 좀 도와주세요  ㅜ.ㅜ

[Top]
No.
제목
작성자
작성일
조회
1069리눅스에서 mssql 데이타 가져올때
김용열
2003-11-28
4549
1068ms-sql에서 큐브를 만들고 나서 데이터의 내용이 보이지 않습니다
전현철
2003-11-28
4194
1067bak 파일 복원
최상현
2003-11-28
5813
1066문제를 풀고 있는데요.......
초보학생
2003-11-28
4408
1065덤프에 관한 문제.... 뷰인거 같은데요....
뺘라밤
2003-11-28
4563
1064[질문]mssql에서 intersect 사용
김종원
2003-11-27
4698
1063MSSQL에서 지원되는 패스워드 함수가 있는지요?
김동우
2003-11-27
4283
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.016초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다