GRANT ALL

Question

Post reply

GRANT ALL

chandlbj

SSC Enthusiast

Points: 123
More actions
April 28, 2004 at 9:48 am

#163554

I don't understand why when I use the following Syntax:
GRANT ALL TO PUBLIC after I have created objects, that the grant is not performed.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mshiva Old Hand Points: 344 More actions · Answer 1

Check whether the permissions are denied at another level such as group or role

chandlbj SSC Enthusiast Points: 123 More actions · Answer 2

Thank you for the response. No, they are not denied anywhere else. I am creating a new database, adding a user, creating an object, and then trying to grant all to public. I know that I can do it by including the "ON" statement, but I am trying to find an all encompassing statement.

David Burrows SSC Guru Points: 65143 More actions · Answer 3

GRANT ALL TO PUBLIC

grants statement access to public, where statement is CREATE DATABASE,CREATE DEFAULT etc. So you have allowed a member of public to create databases !

To grant at object level you have to use ON

GRANT ALL ON object TO PUBLIC

for each object

There is not a 'global' grant for all objects

Far away is close at hand in the images of elsewhere.
Anon.

David Burrows SSC Guru Points: 65143 More actions · Answer 4

If you want to do it for all tables in a database you could use

sp_msforeachtable

Far away is close at hand in the images of elsewhere.
Anon.