September 8, 2014 at 10:52 pm
Hi Everyone,
I have a Question i.e,
I want to create a login with some restriction like the following...
1.I will create a login and ll mapped to a particular DB with the Database Role 'db_datarerader' only,
2.We wants to display the all objects under a DB but we don't want to provide the View Definition to that particular Login.
3.If we Deny the View definition option he can't able to see the Objects which are there under the DB.
4.So My Clear Question is we want to display the Object like tables ,Sps...etc and we don't want to allow him to view the definition of those objects....
Can Any one help me out on this....
PFA...
Regards
Chowdary...
Regards
Chowdary...
September 9, 2014 at 6:55 am
😎
Regards
Chowdary...
September 9, 2014 at 7:04 am
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1611660-1550-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 10, 2014 at 7:03 am
Hi Everyone i got the solution by using the following...
use master
go
deny exec on sp_help to public
use DBName ---DBName is Database name,
go
deny select on sys.all_objects to testuser ---TestUser is the Login Name
deny select on sys.All_columns to TestUser
deny select on sys.all_views to TestUser
Given By Mr.Suneel......
Regards
Chowdary......
Regards
Chowdary...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply