April 18, 2003 at 6:26 pm
Hi,
We Have a sql server 2000 SP3. We recently restored a database which was backed up on SQL 7.0 SP4.
The users and logins are synchronized. But here is the problem.
When we script it out through EM, for some reasons the permissions are not shown, only the blank checkboxes are shown.
Any one has any ideas or suggestions or ideas or solution to this?
Thanks In Advance.
April 18, 2003 at 7:25 pm
Running in compatability mode? If you script a proc out manually using QA, do you get the permissions (assuming you have the option checked in options in QA)?
Andy
April 20, 2003 at 2:34 pm
Hi,
yes I tried through QA with the options checked. Still it does not show me the permissions.
Thanks.
April 20, 2003 at 4:30 pm
If you set new permissions on an object, does it then show up ok, you can script back out? If so then you had a problem with the restore, permissions didnt restore somehow.
Andy
April 21, 2003 at 9:17 am
When I set permission for an Object and try to see if its there, it does not show up. I tried through SQL EM as well as through DB Artisan, but no use. I am pretty sure that the permission is there. Thinking why its not showing up?
Thanks.
April 21, 2003 at 9:46 am
You're absolutely sure the user is not orphaned from the login? How about querying sysprotects to see if rows are in there for the permissions?
Andy
April 21, 2003 at 12:12 pm
Yes there are rows with permissions. Also there are no orphaned users.
Thanks.
April 21, 2003 at 3:10 pm
Hi Andy,
I found a strange problem.
I created a table with one column:
CREATE TABLE X (a INT)
and gave the user INSERT AND SELECT Permissions. The user is able to insert and SELECT, but for some reason it does not show an entry into sysprotects table.
If I revoke any permission say INSERT, the users is not able to insert.
Is there any other place that this info is stored?
Thanks,
VP
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply