Subject | Re: Shut Down Database |
---|---|
Author | robertgilland |
Post date | 2006-03-23T00:15:29Z |
>statements
> It's not as bad as it probably seems to log everyone in as someone
> else. You can still use a surrogate name and still connect everyone
> through that user. You will need to issue a batch of grant
> but I would think there is otherwise little if any code change.This is frightening. This means we have to write a procedure, that
>
> Adam
>
checks if the new user exists, if not add him, then go through all
current Metadata objects and add GRANT access to the new user.
On top of this whenever we create a new Metadata object we have to add
GRANT to the new user as well.
If I don't run these GRANT commands. Does this mean the new user
cannot read/write to any Tables/Views?