|
If I grant execute permissions to a role via
GRANT EXECUTE ON [DBO].[MYPROC] TO MY_ROLE
what's the equivalent syntax to remove them?
Started by Eric on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The first acts as a filter for any granted permissions, the second removes an explict ....
REVOKE EXECUTE ON [DBO].[MYPROC] TO MY_ROLE
DENY EXECUTE ON [DBO].[MYPROC] TO MY_ROLE
or
REVOKE EXECUTE ON [DBO].[MYPROC] TO MY_ROLE
depending on your goal .
|
|
Is there a way I can give developers permission to grant a user permissions over objects without giving them the option to create users or functions?
I'm trying to limit developers permissions, I recently found out that developers had db_owner permissions...
Started by Alan Featherston Lago on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
In effect you use stored procedures....
Members of the "db_securityadmin" database role
As Stefan said, giving them grant permissions would effectively give them all permissions, since if they want to do something all they have to do is grant.
|
|
I need to grant a db_datawriter before executing SqlBulkCopy and remove it after:
try { "EXEC [db_mod].[sys].[sp_addrolemember] N'db_datawriter', N'my_user'" // via SqlCommand bulk.WriteToServer(table); } finally { "EXEC [db_mod].[sys].[sp_droprolemember...
Started by abatishchev on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In order to run ....
Wouldn't it be easier to just grant that user that runs table only?
Something like:
GRANT ALL ON (temporaryTable) TO my_user
That should be sufficient to do the SqlBulkCopy operation.
Try using GRANT and REVOKE .
|
Ask your Facebook Friends
|
Can a person have a grant written;then add the cost of the grant writer fee to the grant?
if so,how would i contact the writer?
i have 4,000 grants that need to be written.
- Was this comment helpful? Yes (24) / No (9)
Answer Snippets (Read the full thread at indeed):
This practice....
Also, the grant writer puts in a lot of work to complete the grant proposal, not paying them for this work is not acceptable.
The most.
No, this is not an acceptable way to compensate a grant writer for several reasons.
|
|
I need to grant privileges to all users, I can do:
GRANT select on table TO user1; GRANT select on table TO user2; ...
But there are many users. How can I grant this privilege to all users at once?
I tried:
GRANT select on table TO ALL;
But that doesn...
Started by Richard Knop on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
grant roles to users..
Grant permission to roles.
You should use roles.
grant select on table to public;
But be careful when you do that -- make sure it's what you really want to do.
|
|
I have a FTP directory permission issue. Under the root directory of my FT directory I have 2 sub directory:
DirectoryA DirectoryB I have granted one machine with the read/write permission to DirectoryB . Does this mean that it will also have the same...
Started by Ngu Soon Hui on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
But make sure you have applied permission....
He will get alert message 505 "Access Denied".
If you have given permission to user for a particular folder, he will not be able to access other FTP directories .
You need to give access to a user not a machine .
|
|
Hi,
Is there a one-liner that grants the SELECT permissions to a new user postgresql?
Something that would implement the following pseudo-code:
GRANT SELECT ON TABLE * TO my_new_user;
Started by Adam Matan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
;" | psql database | grep -v "pg_" | grep "^ "`; do echo "GRANT SELECT ON TABLE $table to my_new_user;" echo "GRANT SELECT ON TABLE $table to my_new_user;" | psql database done
Run from the privileged.
|
|
I need to see all grants on an Oracle DB.
I used the TOAD feature to compare schemas but it does not shows temptable grants etc. so there's my question:
How can I list all grants on a Oracle DB?
Started by furtelwart on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If....
If you need those, use all_tab_privs view instead.
Assuming you want to list grants on all objects a particular user has received :
select * from all_tab_privs_recd where grantee = 'your user'
This will not return objects owned by the user.
|
|
More specifically, how do I show what replication grants is attached to a username?
Started by Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Try this:
mysql> select Host, User, grant_priv, Repl_slave_priv, Repl_client_priv from mysql.user;
This should give you output similar to that below:
+ + + + + + | Host | User | grant_priv | Repl.
|
|
How do I view the grants (access rights) for a given user in MySQL?
Started by idontwanttortfm on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You might want to check out mk-show-grants from Maatkit , which will output the current set....
Mysql> show grants for 'user'@'host'
If you're already running a web server with PHP then phpMyAdmin is a fairly friendly administrative tool.
|
