|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/4/2009 1:40:24 PM
Posts: 4,
Visits: 4
|
|
On creating users not all users have been given a standard comment. As we use staff numbers for logging on its hard to tell who this person is (quickly)
I have wrote a script to search ldap for all the users in the database but can not find a way to update this field (modify user doesn't show the option looking in the manuals). COMMEN ON USER|database also does not work.
Any ideas on how to modify this?
select databasename,commentstring from dbc.databases where databasename = 'username'
If the field I am talking about.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
|
COMMENT ON USER username AS 'anythingyoulike';
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/4/2009 1:40:24 PM
Posts: 4,
Visits: 4
|
|
I tried that, again, and get a 3707:
3707: Syntax error, expected something like a name or a Unicode delimited identifier between the 'USER' keyword and the string '0'.
Output directed to Answerset window
The SQL I have tried:
COMMENT ON USER '1234567' AS 'This is a test comment';
COMMENT ON USER 1234567 AS 'This is a test comment';
Any ideas?
Scratch that just tried as follows:
COMMENT ON USER "1234567" AS 'This is a test comment';
Damn quotes :-)
|
|
|
|