September 29, 2005 at 2:29 pm
I have not created all my stored procedures yet, so i'm still using queries.
I want to grant my approle object permissions
grant select, insert, update, references on employees to faelogin
I have 15 tables! Do i have to list all 15? There isn't a word called ALL!
September 29, 2005 at 3:10 pm
Yes you have to do it to all
just cheat
select 'grant select, insert, update, references on ' + table_name + ' to faeLogin'
from information_Schema.tables
where table_Type = 'base table'
and table_name <> 'dtproperties'
the text ouptput can be copy /pasted into a new query window, and executed. Better yet parameterize so you can use it over and over for other things
Jacob, delete all the other spam postings you did
September 29, 2005 at 3:14 pm
I don't know how! The web server said made an server error. So... I tried to post again. I didn't know it was posting anyway. It just gave me an error on my end. How do you delete a thread?
September 29, 2005 at 3:32 pm
Click edit post on your post, Then click delete post on bottom right
September 29, 2005 at 4:11 pm
Sorry, when i clicke edit post, i don't see anything that allows me to delete the thread.
I see, it works for the following posts but not the starting post.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply