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 1065 게시물 읽기
No. 1065
덤프에 관한 문제.... 뷰인거 같은데요....
작성자
뺘라밤
작성일
2003-11-28 12:06ⓒ
2003-11-28 12:34ⓜ
조회수
4,555

안녕하세요 ^^

다음주에 70-229 를 시험볼예정입니다

덤프를 풀다가 잘 이해가 가질 않아서요

 

You are a member of a database development team for a telecommunications company. Another developer on the team, Marc, has created a table named Customers in the Corporate database.

Because the table contains confidential information, he has granted SELECT permissions on the table only to the other members of your team.
You are developing an application that will allow employees in the marketing department to view some of the information in the Customers table. These employees are all members of the Marketing database role.

To support this application, you create a view named vwCustomers on the Customers table.

After creating the view, you grant SELECT permissions on the view to the Marketing role.

 

When members of the Marketing role attempt to retrieve data from the view, they receive the following  error message:
SELECT permission denied on object ‘Customers’, database ‘Corporate’, owner
‘Marc’.

You must ensure that the members of the Marketing role can only use the vwCustomers view to access
the data in the Customers table. What should you do?
A. Add the marketing role to the sysadmin fixed server role.
B. Transfer the ownership of the vwCustomers view to the marketing role.
C. Instruct Marc to transfer the ownership of the Customers table to each member of the marketing role.
D. Instruct Marc to grant the users SELECT permissions on the Customers table.
E. Drop the vwCustomers view. Instruct Marc to re-create the view and to grant SELECT permissions on
the view to the marketing role.

 

 

 

문제입니다   고수님들좀 이 문제에 대해서 아르켜주세요 답은 E 입니다

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