No announcements
Found 1464469 threads
-
0 VotesGrant Select permission on a table
permissions tab -> click Add -> browse the user to whom u want to give the permission -> click ok -> now u will find various permissions which u can ...Answered | 11 Replies | 117249 Views | Created by Ora-dbaabode - Saturday, September 5, 2009 11:45 AM | Last reply by SQLUserDBA - Wednesday, September 9, 2009 10:33 AM
-
0 Votes
Grant select to one table
You can use GRANT the needed permissions on the object to non-privileged users/roles as needed.Answered | 4 Replies | 6655 Views | Created by Vaishu - Friday, December 16, 2011 3:54 PM | Last reply by Dan Guzman - Tuesday, December 20, 2011 1:13 PM -
2 Votes
Granting permissions to a user to create a table
Additionally, you'll need to grant them ALTER SCHEMA permissions on the schemas that you want them to be able to create tables in.Answered | 2 Replies | 5068 Views | Created by geroido - Friday, October 31, 2008 2:10 PM | Last reply by Aaron Alton - Friday, October 31, 2008 3:41 PM -
2 Votes
Grant select on a view but not to base tables
However, if you created the view in "DB2", you could grant the user access to just the view without also granting select rights to the view's source ...Answered | 6 Replies | 25523 Views | Created by Evgeniya Brileva - Tuesday, October 11, 2011 12:56 PM | Last reply by Crazy Adam - Wednesday, October 12, 2011 2:45 PM -
5 Votes
Granting permissions.
GRANT VIEW ANY DEFINITION But why I am not able to see the permission in proeprties-- permissions sections.Answered | 9 Replies | 1763 Views | Created by venkatesh1985 - Friday, April 17, 2015 5:14 PM | Last reply by dave_gona - Friday, April 17, 2015 6:26 PM -
10 Votes
Grant SELECT, INSERT, UPDATE, DELETE on all table
-- ======== -- (1) exec dbo.spSetRightsOnObjects @mode='GRANT' @objType='TABLES', @user='Meier_F', @substring='TEST_%', @rights='SELECT, UPDATE, ...Answered | 8 Replies | 201323 Views | Created by kio2008 - Monday, July 6, 2009 10:05 PM | Last reply by Steve Nixey - Friday, June 14, 2019 9:19 AM -
0 Votes
Grant Alter Table permission in SQL 2000
PFCUser already has select, update, insert, and delete permissions.Answered | 5 Replies | 17554 Views | Created by Sheldon M. Penner - Tuesday, December 14, 2010 4:30 PM | Last reply by WeiLin Qiao - Thursday, December 16, 2010 12:16 PM -
0 Votes
Grant SELECT on all tables to an application Role
Here are a few options (first two are two synax for the same thing, SELECT permissions on a database).Answered | 3 Replies | 12135 Views | Created by SQL Rob - Monday, April 20, 2009 12:47 PM | Last reply by SQL Rob - Tuesday, April 21, 2009 8:14 AM -
2 Votes
Granting execute permission to all procedure with select query
The permission to change the table by using the proc came from "ownership chaining".Answered | 2 Replies | 4247 Views | Created by urprob - Sunday, February 26, 2012 12:09 PM | Last reply by Rick Byham, Microsoft - Monday, February 27, 2012 4:22 PM -
1 Votes
Best practice for granting permissions
GRANT EXEC ON some_sp TO nisse -- Grant permission on a single procedure.Answered | 2 Replies | 6864 Views | Created by uopwebdev - Wednesday, October 20, 2010 8:30 PM | Last reply by uopwebdev - Thursday, October 21, 2010 4:37 PM -
0 Votes
Permissions being granted twise
You can use the function fn_my_permissions in order to check the user permissions on the specific object.Answered | 2 Replies | 684 Views | Created by moondaddy - Thursday, October 23, 2014 8:09 PM | Last reply by pituach - Thursday, October 23, 2014 10:26 PM -
1 Votes
Store Procedure Grant Execute Permission
That would allow users to see the meta-data even without other permissions on the table.Answered | 4 Replies | 1087 Views | Created by Priya Bange - Saturday, September 1, 2018 6:14 AM | Last reply by Dan Guzman - Saturday, September 1, 2018 1:10 PM -
1 Votes
How to grant Create table permission in tempdb?
Users need permissions the table schema in addition to database level CREATE TABLE permissions.Answered | 10 Replies | 12299 Views | Created by Julie Elizebeth Sam - Tuesday, June 7, 2016 7:17 AM | Last reply by Erland Sommarskog - Wednesday, June 8, 2016 9:05 PM -
1 Votes
Granting user "WITH GRANT" permission to run procedure.
Perhaps there is an update trigger on one of the tables that accidentally had a GRANT statement included in the trigger code.Answered | 12 Replies | 10361 Views | Created by David_VNV - Friday, June 24, 2011 5:31 PM | Last reply by Erland Sommarskog - Thursday, June 30, 2011 9:40 PM -
0 Votes
Grant Permission In Access Database
Hello Matthias, its still error, But Ok, I found the solution look at this linkAnswered | 7 Replies | 971 Views | Created by Xan To - Thursday, March 26, 2015 7:01 AM | Last reply by Xan To - Monday, April 6, 2015 9:57 AM -
0 Votes
Grant Permissions database versus object
As for the question on where to grant permissions, my preference may to grant on schema level, to permit some differentiation.Answered | 3 Replies | 1033 Views | Created by donsjones - Monday, August 15, 2016 3:23 PM | Last reply by Erland Sommarskog - Monday, August 15, 2016 9:41 PM -
0 Votes
grant developer access to tables
Although a user can select from the catalog views and DMVs, meta-data ...Answered | 3 Replies | 1232 Views | Created by KirkSH - Monday, January 20, 2014 4:07 PM | Last reply by Dan Guzman - Monday, January 20, 2014 5:35 PM -
1 Votes
Is it possible to use "grant" to grant the permission for BULK INSERT
If it doesnt permission, it executes SQL Transact (Executes on a Database that has all permissions, but this database only do ...Answered | 5 Replies | 16953 Views | Created by William. W - Tuesday, August 17, 2010 8:17 PM | Last reply by Erland Sommarskog - Wednesday, August 18, 2010 10:21 PM -
0 Votes
grant permission
Hi there, It depends on the level of permission that the login you have used.Answered | 3 Replies | 2510 Views | Created by vipulparmar2510 - Sunday, December 23, 2012 3:57 PM | Last reply by Fanny Liu - Monday, December 24, 2012 6:04 AM -
0 Votes
Grant a user the select permission on a view that references external objects
4) Grant select in SRC_DB for the user The user will be able to read from the views, but not from the source tables.Answered | 4 Replies | 902 Views | Created by Andrea Caldarone - Thursday, March 5, 2015 4:35 PM | Last reply by davidbaxterbrowne - Thursday, March 5, 2015 11:12 PM - Items 1 to 20 of 1464469 Next ›
No announcements
