?
Solved

sql schema issue

Posted on 2012-09-11
1
Medium Priority
?
363 Views
Last Modified: 2012-09-12
hi
 i try to create a view  in schema, the view will have some masking to block some information on a table

example
CREATE VIEW myschma.vw_address AS
      SELECT ***, *** FROM dbo.address

GRANT SELECT ON SCHEMA::myschma TO tempUser

i got an error when i sign in as tempUser and run the vw_address.

error
The SELECT permission was denied on the object 'address', database 'dbname', schema 'dbo'.

i don't want tempUser has select on dbo.address. only the view with masking.
if i put the view in dbo without schema, it will work, but i want this view in schema, any idea, thank you so much.
0
Comment
Question by:tristonyip
1 Comment
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 2000 total points
ID: 38389830
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question