Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » Security (SS2K8) » view defination
Add to briefcase

view defination Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
geetha@in
Posted Wednesday, March 02, 2011 4:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:37 AM
Points: 173, Visits: 565
Hi all,

how to give the permissions to user for view definition of Object in sql server 2008 r2


Thanks to all
Post #1071818
Dwayne Dibley
Posted Wednesday, March 02, 2011 4:51 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 365, Visits: 2,912
I find Google quite useful when I can't remember the syntax of a command: http://www.mssqltips.com/tip.asp?tip=1593
Post #1071829
Ysaias Portes-QUI Group
Posted Tuesday, April 12, 2011 7:13 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 12:30 PM
Points: 73, Visits: 305 
GRANT VIEW DEFINITION

Check this link:[url=http://msdn.microsoft.com/en-us/library/ms175808.aspx][/url]

QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
Post #1092527
sherwincurt
Posted Wednesday, April 13, 2011 4:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 06, 2011 1:23 AM
Points: 8, Visits: 15
I am not able to restrict user.

He still able to see all the data.
Post #1092709
GilaMonster
Posted Wednesday, April 13, 2011 5:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 38,062, Visits: 30,359
Is he a member of db_datareader? A member of db_owner? a member of sysadmin?

Granting view definition doesn't remove permissions, it adds permissions

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1092756
Syed Jahanzaib Bin hassan
Posted Tuesday, April 26, 2011 5:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481
If you want to restrict user can see only definition of the objects then remove all rights exclude public then give VIEW DEFINITION

Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com

Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com
Post #1098527
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.