Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

view defination Expand / Collapse
Author
Message
Posted Wednesday, March 2, 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
Posted Wednesday, March 2, 2011 4:51 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 7:36 AM
Points: 377, Visits: 3,063
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
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: Tuesday, April 8, 2014 10:49 PM
Points: 73, Visits: 320
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
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 6, 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
Posted Wednesday, April 13, 2011 5:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 42,756, Visits: 35,850
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
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