July 20, 2002 at 10:45 pm
I screwed something up where I have a user connecting to a db and now it requires the username.tablename. I look at the tables and the owner is the name of the person I am logging in as via Query Analyzer. I don't know why all the sudden this has affected this. Is there a fix or ideas as to why I am having this problem?
Please help...
Neli
July 20, 2002 at 10:47 pm
Got it 🙂 I changed a bunch of permissions on that user. I removed them and its all better now...
Thanks...
Neil
July 21, 2002 at 6:56 am
So the objects were correctly owned by the user? Or you changed them?
Andy
July 21, 2002 at 11:16 am
I checked all privleges for that user. I am trying to allow this user to make FullText Catalogs. Do you know what permissions on which DB he will need?
Neil
July 21, 2002 at 6:46 pm
Havent ever looked, cant imagine letting my users do it! Looking at sp_fulltext_table I see this:
Permissions
Only members of the sysadmin fixed server role, db_owner and db_ddladmin fixed database roles, and the object owner can execute sp_fulltext_table.
Andy
July 21, 2002 at 7:34 pm
can I add a user to that role?
neil
July 21, 2002 at 7:40 pm
Sure. The caveat is that you're granting them greater access than they need. If you're ok with that go for it!
Andy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply