Re: UID or username

Hi, All!

Peter Laursen wrote:

> I need to decide whether to store the userid (a number) or the username (a
> string).
> Say the db is exported and imported what happens to the UID's?
>

If You can recreate users with the previous UID (it's simple -- You have to control _next_user parameter in sys.user$ when You create a blank database and control missing user# in sys.user$), then You can use both methods, otherwise -- USERNAME.
> Say users are dropped and created, what happens to the UID?
>

If You use uid in records You can drop user without permissions but "his" records will be "hanging".

>
> Oh , maybee i should just use em both!
>

If Your admin drop a user -- the record will be "hanging".

>
> Peter

Ivan Received on Thu Nov 18 1999 - 11:13:11 CST